View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
 
Posts: 563
Default 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