Create pie chart in excel mac how to#
Create pie chart in excel mac update#
Create pie chart in excel mac manual#
Create pie chart in excel mac series#

Create pie chart in excel mac update#

The doughnut chart will automatically update with a second outer layer:

Create pie chart in excel mac series#

In the new window that pops up, click Add to add a new data series.įor Series values, type in the range of values fpr Quarter 2 revenue:Ĭlick OK. Data is provided as is, by Freddie Mac with no warranties of any kind, express or implied. Options include flat pie shapes, 3D pie shapes, and pie charts with exploded pieces.

The other two charts have three data series: Vendor 1, Vendor 2, and Vendor 3. In the Insert Chart dialog box, select Pie and choose a pie chart style. Right click on the doughnut chart and click Select Data. The pie and single line charts reflect the data in column B for Vendor 1. Step 3: Add a layer to create a double doughnut chart. The following doughnut chart will automatically appear: On the Data tab, in the Charts group, click the icon that says Insert Pie or Doughnut Chart. Perform the following steps to create a double doughnut chart in Excel.Įnter the following data into Excel, which displays the percentage of a company’s revenue that comes from four different products during two sales quarters:

Create pie chart in excel mac how to#

This tutorial explains how to create a double doughnut chart in Excel. It’s similar to a pie chart except it has a hole in the center, which makes it look more like a doughnut.Ī double doughnut chart is exactly what it sounds like: a doughnut chart with two layers, instead of one. Use the sliders in the task pane to achieve this.A doughnut chart is a circular chart that uses “slices” to display the relative sizes of data.

You may want to experiment with the gap between the two pies as well as the size of the second plot (Microsoft’s jargon for the second pie). The basic method you can use is to create pie charts for each bubble, modify the formatting of the pie charts to eliminate everything but the pies from view (turn off borders, any text labeling, backgrounds, etc. Custom – allows you to manually select a slice and then designate a plot.Percentage value – like value, but here you specify a % threshold.Value – this allows you to specify a threshold under which values are moved to the second pie.In the Split Series menu you will find three more options: Position is not the only way Excel allows you to specify which categories are placed in the second pie. In your task pane you can now change the Values in second plot setting. In Excel 2013, right-click on one of the pies and select Format Data Series. You can change the number of categories that move to the second pie. In my chart data (opposite), I’ve sorted the sales values in descending order so that worst performers end up in the second pie. So how does Excel decide which categories of data to put in the second pie? By default it selects based on position, selecting the last three categories in your chart data. “Other” represents the combined share of the categories in the second pie. On the Chart Design tab, select Select Data.

Create pie chart in excel mac manual#

Now I will show you how to build an excel chart with manual selection of the data.Select Switch Row/Column.Line graphs, bar graphs, pie charts, stacked charts, area charts, etc. Step 1: Place the cursor in the empty cell and click on the insert chart. Notice that the main pie includes a slice called “Other”. Step 2: After you click on Insert Chart, you will see an empty chart. Their slices would have looked tiny on the main pie chart, but moved over to the second pie – they are much easier to read. In the example below Bert, Brenda and Barbara ended up getting the smallest share of sales for 2013. The Pie of Pie chart type is in this menu. To create a Pie of Pie, click into your chart data and on the Ribbon’s INSERT tab click on the Pie button in the Charts group. A pie of pie chart will enable you to move these small slices to a separate pie chart so that they are easier to read. Pie of Pie charts are useful if you have several categories of data that end up representing small slices in your pie chart.