Can I create multiple graphs into one chart? (example provided)

[Optimesh]

Hello all,
I have a table with 3 sales metrics (one for each of 3 regions) across the months of the year.
The horizontal and vertical axis should be identical for all three.

What I'd like to do is to plot all three, stacked one on top of another, in one single graph, automatically.
I attach an example to the desired result, which I of course created by some magic. What I did was to just create three separate graphs and superimposed them one on another.

Anyway to get excel to do it easily, all nice and alligned ?

pic: Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting

Thanks in advance,
Op.

 

[Andrew Poulsom]

Can't you put all three series on the same chart?

 

[Optimesh]

Unfortunately, no. My superiors don't like it when lines intersect. Don't ask

 

[Andrew Poulsom]

Maybe this will help you:

Excel Panel Charts with Different Scales

 

[Optimesh]

Thank you.