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