#Can i make a pie chart in excel series#

Press & Drag the pie chart below the data The pie chart is displayed, but we need to make a few changes. To select the pie chart, in the first row, We want the default type: a straightforward, two-dimensional pie chart. There are several pie chart subtypes to choose from.

To select the appropriate chart type, in the Charts group, To begin the process of inserting a chart, on the Ribbon, The data labels and the Total values are selected. NOTE for MacOS Users: To add the Total data to the selection, press Command key and Press & Drag the cell range H3:H8. To add the Total data to the selection, press:Ĭontrol key and Press & Drag the cell range H3:H8 Now we want to select the data in the Total column to use to make the slices of the chart. We will use the control key to make a non-contiguous, or non-adjoining, selection. To accurately chart this data, we need to select the data labels in column A, and the total values in column H. We want to make a pie chart that shows the total workshop participants as parts of a whole.

#Can i make a pie chart in excel series#

Therefore, we will select only the data series we want to chart along with the appropriate labels. On this worksheet, however, we have several sets of data namely, categories of workshop participants who have taken our workshops for six months. The primary characteristic of a pie chart is that it charts one series of data. To move to the Pie Chart worksheet,Ī worksheet appears listing the numbers and types of participants who took our workshops for a period of six months. Let's move to the worksheet with the appropriate data. Today, we will be using a pie graph to show the different participants who took our computer workshops over a period of six months. For example, the pie chart below shows that election poll results could be plotted on a pie chart, with each candidate's percentage of the vote visible as a 'slice' of the pie: Pie charts tend to be the most useful when there are a small number of data points since too many data points will make a pie chart difficult to interpret. This means that a pie chart can only use one data series, and that no value can be a negative number. Use the sliders in the task pane to achieve this.Pie charts show the relative proportion of any part to the whole. 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).

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. Notice that the main pie includes a slice called “Other”. 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.