Combining multiple charts into one

[Jaymond Flurrie]

I'm pretty new to using charts with Excel. I have these charts, which I would like to combine to one, so that the axis values and chart title would be common, while these "stacks" would be next to each other, with own values and own value labels. What kind of chart would be the smartest solution to use?

 

[njimack]

Like this?

By the way, 3D charts should be avoided at all costs.



Uploaded with ImageShack.us

 

[Jaymond Flurrie]

Like this?

By the way, 3D charts should be avoided at all costs.

Yeah, that seems good. If you can add there the labels what each color in each "stack" means, that's exactly what I'm looking for. I guess I can live with that kind of range you created there, I just need to use VBA to generate it atomatically every time I come to the sheet, but that's an easy thing to do. I would just need to know how to create that kind of chart.