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.