Stacked Line Chart - Excel 2007 - Controlling the separation
 

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

Stacked Line Chart - Excel 2007 - Controlling the separation
 

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Harry" wrote in message
...
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

Stacked Line Chart - Excel 2007 - Controlling the separation
 

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.




"Harry" wrote:

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