That means, in the case of the example above, that the two combined data points of 24.78% and 18.58% respectively are shown in the pip element as 57.14% and 42.86% respectively: the Comb % in the table below. The pip element of the pip chart, the right hand part of the diagram shows the combined values in proportion to each other: the Pie % in the table below. Those two points are then shown on the right of the diagram. In the pip chart in the introduction we see what I called a 2 Pie in a 4 Pie chart: in this case there are four data points in the series and Excel has chosen the final two data points in the series to combine into one slice in the pie on the left. A subsidiary pie which explains the detail of the combined series.The pie itself which, however, combines one, two or more of the data points, depending on the total number of data points in your series.However, other people don’t!Ī pip chart is a double helping of a pie chart: I have to say at this stage that some people absolutely loathe pie charts. We will also consider some additional points that you should find useful too. how many slices will be combined in the final slice.What we will see here is what a pie in a pie (pip) chart is I have called this a 2 Pie in a 4 Pie for a reason that will become clear in a moment. This page concerns what Excel calls a Pie in a Pie Chart, which looks like this:

How to make a pie chart in excel 2010