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

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.

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.

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

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.

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.

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

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" wrote:

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.

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

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


"lrb" wrote in message
...
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" wrote:

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.