pie chart question
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.
"jlc" wrote:
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
--
jlc
|