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

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

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


"Amery" wrote:

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

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

--
Regards,
Fred


"jlc" wrote in message
...
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