Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Secondary Y axis and more with Pivot charts... | Excel Discussion (Misc queries) | |||
Secondary Y axis and more with Pivot charts... | Charts and Charting in Excel | |||
Secondary axis on 3d charts | Charts and Charting in Excel | |||
Cluster charts and the secondary y-axis | Charts and Charting in Excel | |||
bar charts with secondary y axis | Charts and Charting in Excel |