View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
twagner twagner is offline
external usenet poster
 
Posts: 3
Default pie chart areas reflect magnitude

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.