View Single Post
  #2  
Old August 28th, 2009, 04:27 AM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default pie chart areas reflect magnitude

At best this will produce a set of cartoons which is semi-qualitative
and non-quantitative.

If you post some typical data, perhaps someone could attempt a better
chart type.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



twagner wrote:
I want to show several pie charts all on the same scale.

Example: chart 1 values total to 10, chart 2 values total to 100. So chart
1 is scaled so its area=10, and chart 2 is scaled beside it so its area=100.
That would show not only the values of the parts in each pie chart, but the
comparison in magnitude between charts 1 and 2. In this example, chart 2 is
a much greater value, and therefore bigger pie chart.

How can I do that?

I tried it with bar charts, could not find what I wanted there, either.