Multiple pie charts for large data

[sara07]

Hi, I have created a pie chart which divided into three years but the problem is for 2010 and 2011 i have about 100 countries with percentage that are too many for the pie chart. I tried the bar chart too but columns are overlapping and cant see the values or country properly. I was wondering if there is any way I could divide into two pie charts?

For example: for 2010 year
1 chart display 50 records and
2 chart display another 50 records side by side for this year?
Is this possible?
Please help i am stuck!

 

[lbass]

You could apply topN and bottomN to the same dataset for two different pie charts, e.g., one pie is top50, the other, bottom50.

-LB

 

[hilfy]

However, if you think about it logically, having two pie charts give a misleading view of what the data represents - pie charts are about showing the percentage of the whole amount that is related to each section. In this case, two pie charts will show the percentage of an unknown total.

I would use two bar charts instead of two pie charts in order to provide a more meaningful view of the data.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[lbass]

hilfy is obviously correct on this--I wasn't thinking clearly. You could consider adding an outer group that clusters your countries and then use a bar chart in the group footer, suppressing the detail section and group header. Then you could stretch it out the width of the report.

-LB

 

[TeyBrady]

A Horizontal bar chart works pretty well when you are comparing a large number of items like you are or even as few as two items. Having the data ordered when doing this is usually a good idea. Make sure you keep all the bars the same color since the different colors will have no meaning. A legend will not be required because the horizontal chart is self labeling.

Save the pies for dessert...