Do the same for, say, the ranges aaa, ccc and fff … keep doing that until you have explored each pip … You can do what I said there, force data points bbb, ddd and ggg into the final three places in your data range. Here’s one way I have thought of, following on from the previous section. I am sure there are many ways of using your pip chart to communicate data effectively.
How to use Your pip Chart to Communicate Data I know, not so smart but it works!Ĭonsider the next section, how to use your pip chart to communicate data now to take things a little bit further. Suppose you don’t want the smallest values but you do want, for example, data points bbb, ddd, ggg in a 3 Pie in a 7 Pie example? Well, just put them in the final three places in your data range. By sorting the data, your combined slice will automatically contain the 1, 2, 3 … smallest values. It doesn’t take the largest numbers of the smallest, it just takes the last one or two or three data points and combines them.įine! At least we know what it is doing! How can that help us though? It can help in this way. When you just enter some data into your worksheet and then create your pip chart, Excel just gives you your pip chart. How to Take Some Control of Your pip Chart Please note: I used the trendline for this and it MIGHT be inaccurate here and there but I don’t think so! These are the starting points of our slices: for one and two data points, there will be a combined slice for 3, 4 and 5 data points there will be 2 combined slices for 6, 7 and 8 data points, there will be 3 combined slices. I then used trendline analysis to find in general as follows: You will get a 3 Pie in a 7 Pie chart and a 4 Pie in an 11 Pie chart.
With a little bit of experimentation I found that a pie with four data points will give us the 2 Pie in a 4 Pie chart. How Many Slices will be Combined in the Final Slice?Īt first you might be mystified at how Excel decides how many data points it should combine in the final slice of the initial pie: the pie on the left of our pip diagram. That’s it! That’s all you do.Įxcel will tell you how many of the slices are to be combined together, which are then shown as the right hand element of your pip chart set up. That is, choose the middle of the three pies shown under the heading 2-D Pie. In this case, the chart we want is this one … Take a look at the Excel file that accompanies this page where all of these values are clearly set out for you:ĭrawing a pip chart is the same as drawing almost any other chart: select the data, click Insert, click Charts and then choose the chart style you want. 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 is in the visible property of the screen.This page concerns what Excel calls a Pie in a Pie Chart, which looks like this: ) /* All that collection is the data for the piechart */ If(Priority = "High" Collect(OnHold_C 1)) /* Here, you ask the value of Priority on the line you are on : depending on that value, you just add '1' in the collection that correspond with your browse*/ĬlearCollect(PieData /* Here, you create a collection with 4 lines, getting and the number of rows in the collections that correspond (you've got 1 line at each occurence) */ You set the OnVisible statement of your sheet to : Clear(High_C) Ĭlear(OnHold_C) /* Here, you empty all the collections you'll use after */įorAll(ExcelData /* Here, you just browse your file line by line */ You have your Excel file linked to the Powerapp ( ExcelData ).