View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Two secondary charts in a bar of pie or pie of pie chart?

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
_______


"KMJ95" wrote in message
...
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!

--
KJ