Stacked Line Chart - Excel 2007 - Controlling the separation

H

Harry

When I make a stacked line chart with two series, each point in the 2nd
series appears to have a value that's twice of its' actual value.
I attribute this to the separation of the two series.

Is there any way to control this?

thanks,
Harry
 
B

Bernard Liengme

In a stacked chart, the second data series is essential added to the first.
Suppose I have
Day East West
Mon 10 12
The East point will be plotted at 10 units above the x-axis and the West
will be 22 units (10+12) - it is plotted 12 above the East point.
If you want it plotted at 12 above the axis do NOT use stacked
best wishes
 
T

trip_to_tokyo

I have just put up a file for you at:-

www.pierrefondes.com

It is time number 44 towards the top of the home page.

This is based on MS documentation.

Looks OK to me so cannot reproduce your issue.

Please hit Yes if my comments have helped.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top