Mixed Column Types in One Chart
 

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?

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