Can you create side-by-side pie charts for comparison?

[Guest]

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.

 

[Jon Peltier]

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/
_______

 

[Guest]

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]

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/
_______

 

[Guest]

My problem is this ... I ended up making two pie charts (each has a text box
beneath) and while I could get them to look "right" on the page I'm not able
to paste them into our website because of the "blank/white area" which
surrounds them. I read several posts regarding shrinking this area, but
cannot figure out how to make it smaller without reducing the size of the pie
charts/text boxes ... HELP! I need pie charts for dummies! Any SIMPLE
advice?

 

[Jon Peltier]

When you shrink the overall chart (the Chart Area or ChartObject),
everything inside shrinks accordingly, which MS must think is helpful, but
usually it isn't really. This means you have to shrink the chart area, then
expand everything within it.

Or, since the charts must be exported as image files (I hope you're using
GIFs or PNGs and not JPGs), simply load them into an image editing program,
and crop them to remove all the blank empty space around the meaningful bits
of the charts.

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