pie/bar-of-pie charts

[Leslie]

Please forgive two questions by a rank beginner:

1. Is it possible to have a central pie chart surrounded by a number of
either pie or bar charts, each of the satellite charts giving further
information about only one slice of the central pie chart?

2. Is it possible to change the colour of some columns only in the simplest
sort of column chart, that is, where the columns aren't clustered or
stacked?

 

[K Dales]

1. You can, of course, do pie chart that breaks out one
series in more detail, but I am not aware of any way to do
multiple "satellite" charts (unless perhaps this might be
possible with some custom VBA coding - but if so would be
terribly complex). However, why not create each of the
charts separately and arrange them however you need them
on your worksheet page?

2. Yes, you can change the colors of any column as you
wish. If you click your mouse on the column, you select
the entire series (and if you try to format it will affect
all the columns). However, click again and now you have
selected the individual column (i.e. a single data point)
and then right-clicking brings up the format options to
let you adjust the formatting for just that one column.

Hope this is the info you need.

 

[Jon Peltier]

Following up on #1. There is no way to get multiple pies of pie in a
single chart, VBA or not. The suggested approach, making individual
stand alone pies for each subset, is the way to go.

- Jon

 

[Guest]

May I add a supplementary question to my earlier ones?

Under the heading "Create a chart" in the online help for Excel, there's an instruction to make sure the data on your worksheet is arranged properly for the type of chart you want to use. Under pie charts, there's a reference to a "regular" pie chart and then to a "stacked" pie chart. I don't understand the latter reference. Is that an indirect way of referring to pie/bar-of-pie charts or is it something else?