Adapting Stacked Charts With vertical separation

[lu_argenitna]

Hi!
I'm trying to replicate this kind of chart:
http://peltiertech.com/Excel/Charts/StackedCharts.html
But instead of one line per range, I need 3 lines. Have someone worked with it? I'm trying to figure out how to manage the series but it's impossible!
Thanks!
Cheers.

 

[Steve=True]

It is not impossible, but you need to arrange your data in a transposed manner to get the desired effect.

Here is the way you need to group your data with blank columns and rows.

http://www.4shared.com/document/TNVfclNM/test-multi-clustered-stacked-c.html

 

[lu_argenitna]

Thanks Steve. I can't download the file at work. Could you please send it by email? My email is lucianapadua 04 @ yahoo dot com
thanks in advance!!
Luciana

 

[Steve=True]

sent, let me know if you don't get it.

thanks

Steve=True

 

[lu_argenitna]

got it!!! thank you very much!

 

[Steve=True]

Great glad it worked for you.

Here is what the final chart looked like:

Sample File: http://www.4shared.com/document/TNVfclNM/test-multi-clustered-stacked-c.html


Steve=True
www.exceldashboardtemplates.com

 

[Jon Peltier]

You just have to set up the calculated Y values so that more than one series fits within each panel of the chart.