Posted to microsoft.public.excel.charting
|
|
Mixed Column Types in One Chart
Hi,
Have a look here
http://peltiertech.com/Excel/ChartsH...sterStack.html
Cheers
Andy
LarryP wrote:
Looking for a way to mix column types in a single chart. Basically I want
three clustered columns each month, BUT: first column is based on a single
value, second column is based on a single value, third column is a stack of
two values. Something like this (not sure this'll display right when
posted, but worth a try, a picture's worth 10,000 words):
d d
d d a d
b d a d a d c
a b c a b c a d a b c
a b c a b c a b c a b c
_______________________________________
Jan Feb Mar Apr
Anybody have any suggestions on if/how that can be done?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
|