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

If one chart is not a subset of the other, as you indicate in your first
post, don't complicate your life by trying to make a pie of pie type.

I am a devout adherent to the Keep It Simple Stupid principle. Sometimes,
using two charts is simpler than using a single chart which is designed for
complicated situations.

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


"lrb" wrote in message
...
Hi Jon,

I've been looking on some other responses you gave related to pie by pie
charts. Will that route work just as well? I think you referred to
Andy's
website ... I'm trying now to figure out how to create the pie by pie
charts.
Which way is easier? I'M DEFINATELY A NOVICE! Thank you! Lisa

"Jon Peltier" wrote:

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.