Two secondary charts in a bar of pie or pie of pie chart?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KMJ95 - 13 Oct 2007 20:16 GMT

Hi -- does anyone know if it's possible to have more than one secondary chart
in a bar of pie or pie of pie chart? For example, if I have a main pie
divided into two wedges--one showing the total number of cars and one showing
the total number of trucks--and I wanted to have a secondary bar for each
wedge showing the car models and truck models.

As far as I can tell, I can only have a secondary chart for one wedge, not
both.

Any help is greatly appreciated -- thanks!

Signature

Reply to this Message

Jon Peltier - 14 Oct 2007 02:08 GMT

If you must use a pie as the basic chart you can get the effect you want by
making two independent charts, one based on one subset of the data, and the
other based on the other subset of the data. Move the secondary charts
around until the alignment is right, and make their chart areas transparent
without a border so thy don't obscure the main chart.

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

> Hi -- does anyone know if it's possible to have more than one secondary
> chart
[quoted text clipped - 8 lines]
>
> Any help is greatly appreciated -- thanks!

Reply to this Message