ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Two secondary charts in a bar of pie or pie of pie chart? (https://www.excelbanter.com/charts-charting-excel/162027-two-secondary-charts-bar-pie-pie-pie-chart.html)

KMJ95

Two secondary charts in a bar of pie or pie of pie chart?
 
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

Jon Peltier

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





All times are GMT +1. The time now is 04:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com