pie chart question

G

Guest

The situation is that I have a list of products and how much we sold of each
one in 2006. I want to take the top 10 products of the list and put them in
a pie chart to show how much of the TOTAL of all products they are. A
percentage of the total if that makes more sense.
The problem is the pie chart uses the total of the 10 products instead of
the total of ALL products. Can anyone tell me how to do this? I'd greatly
appreciate it.
Thanks
 
G

Guest

Have you tried creating a pie chart using all products, and then pulling out
the individual pieces that make up the top 10? This would seperate the top 10
from the rest of the products, and give you the percentages you want.
 
G

Guest

This would be okay if I didn't have so many products in the chart. I have
more than 100 products....
 
F

Fred Smith

My suggestion is to sum the bottom N-10 products. Label this 'Other'. Now graph
the 11 amounts.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Can a pie of pie chart use animation/transitions? 1
Excel Charts 1
Show Total In a Text Box in a Pie Chart 2
Display one cell as a pie chart 2
Pie Chart 2
Pie Chart Question 1
Chart Help 1
pie chart areas reflect magnitude 5

Top