View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Can you create side-by-side pie charts for comparison?

Make two identical but separate charts. If the categories and colors are to
be the same, make the first chart, then make a copy of it, arrange it just
so, then use Source Data on the Chart menu to select the other data range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"lrb" wrote in message
...
I need to show two pie charts side-by-side for comparison. One chart is at
100% participation in one plan option. The other chart (not a
sub-division
of the 100%) shows three plan options at 58% participation, 38%
participation
and 4% participation. I don't want to use something like a pie of pie
chart
because the 2nd chart is not related to the first chart. They are just to
be
used for comparison. Any advice would be appreciated. Thank you.