Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - percentage and values on 100% line/column stacked charts | Charts and Charting in Excel | |||
How do I Excel chart 2 stacked values with third value as a line? | Charts and Charting in Excel | |||
How do I add a goal line to a stacked bar chart in excel? | Charts and Charting in Excel | |||
How do I add a trend line to a stacked chart in Excel | Charts and Charting in Excel | |||
Stacked Charts w/ Vertical Separation | Charts and Charting in Excel |