Pie Chart Help - I Want To Hide Values/Use Values But Not Show In Chart

Hi All,

Quick one....

I have created a pie chart showing top 10 best selling categories. However, on this pie chart, I want %age of overall sales to be shown.

At the moment say I put in the following

Catalogue 1 100
Catalogue 2 98
Catalogue 3 92
Catalogue 4 85
Catalogue 5 84
Catalogue 6 75
Catalogue 7 74
Catalogue 8 66
Catalogue 9 64
Catalogue 10 62

I add Data Labels and select the percentages. This shows at Cat 1 having 12.5% of the sales (100 of 800 sales), Cat 2 having 12.25%, and so on..... However, what you don't see is the following data:

Catalogue 11 60
Catalogue 12 58
Catalogue 13 57
Catalogue 14 57
Catalogue 15 56

So based on 1,088 sales, Cat 1 at 100 is actually only 9.19% of TOTAL sales.




I understand what is happening, the chart is giving the percentage based on the data inputted into the chart.

I did consider adding an 11th category to the chart, which was the total of Catalogues 11-15. Whilst this does give a more accurate percentage figure (as now all sales have been inputted), it makes the chart look ****

Is there a way of either adding the 11th category, and then "hiding" it, so that the chart doesn't display it, but uses it's value to calculate Catalogues 1-10s percentage?





Thanks.



BTW: The reason I ask is that I could be dealing with anywhere from 30 to over 100 catalogues. So it's not ideal showing the others in 1 chart.

Hello
If you're only displaying percentages on the chart and the top ten, then perhaps you could create an extra column with the percentages for each Catalogue based on a sum of all sales and use this as your chart values. For example if your sample data above were in cells B2:B16, then in C2 down:

Please Login or Register  to view this content.

Here A2:A11 and C2:C11 would be your chart source filtered on Top Ten.

DBY