Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.charting




Different Starting Points on XAxis
Hi there,
I'm trying to plot an exponential smoothing line chart with xvalues from 1 to 20. There are two series, the original data points and the smoothed data points. The problem with this is that the starting point is different. For the original data points (series1), the first value starts at 1 and goes to 20. For the smoothed data points (series2), the first value starts at 2 and goes to 20. When I try to chart the line graph in Excel 2003 by selecting the yvalues for series2 starting at x=2, the chart actually begins at x=1. I was just wondering if anyone knows how to change the starting point for a series in a line graph (if possible). Thank you! Xavier 
#2




Answer: Different Starting Points on XAxis
Steps to change the starting point for a series in a line graph in Excel:
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.charting




Different Starting Points on XAxis
Are you making a LINE or XY chart? Should be the latter.
 Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Xavier" wrote in message .. . Hi there, I'm trying to plot an exponential smoothing line chart with xvalues from 1 to 20. There are two series, the original data points and the smoothed data points. The problem with this is that the starting point is different. For the original data points (series1), the first value starts at 1 and goes to 20. For the smoothed data points (series2), the first value starts at 2 and goes to 20. When I try to chart the line graph in Excel 2003 by selecting the yvalues for series2 starting at x=2, the chart actually begins at x=1. I was just wondering if anyone knows how to change the starting point for a series in a line graph (if possible). Thank you! Xavier 
#4
Posted to microsoft.public.excel.charting




Different Starting Points on XAxis
I've done both, and even when I set the correct xvalue range, series 2
always starts at x=1 and goes to x=19. "Bernard Liengme" wrote in message ... Are you making a LINE or XY chart? Should be the latter.  Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Xavier" wrote in message .. . Hi there, I'm trying to plot an exponential smoothing line chart with xvalues from 1 to 20. There are two series, the original data points and the smoothed data points. The problem with this is that the starting point is different. For the original data points (series1), the first value starts at 1 and goes to 20. For the smoothed data points (series2), the first value starts at 2 and goes to 20. When I try to chart the line graph in Excel 2003 by selecting the yvalues for series2 starting at x=2, the chart actually begins at x=1. I was just wondering if anyone knows how to change the starting point for a series in a line graph (if possible). Thank you! Xavier 
#5
Posted to microsoft.public.excel.charting




Different Starting Points on XAxis
Nevermind, I got it working now. Thanks for suggesting XY scatter. I played
around with it a little more and was finally able to alter the starting point. Thank you! Xavier "Bernard Liengme" wrote in message ... Are you making a LINE or XY chart? Should be the latter.  Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Xavier" wrote in message .. . Hi there, I'm trying to plot an exponential smoothing line chart with xvalues from 1 to 20. There are two series, the original data points and the smoothed data points. The problem with this is that the starting point is different. For the original data points (series1), the first value starts at 1 and goes to 20. For the smoothed data points (series2), the first value starts at 2 and goes to 20. When I try to chart the line graph in Excel 2003 by selecting the yvalues for series2 starting at x=2, the chart actually begins at x=1. I was just wondering if anyone knows how to change the starting point for a series in a line graph (if possible). Thank you! Xavier 
#6
Posted to microsoft.public.excel.charting




Different Starting Points on XAxis
Thanks for the feedback
Best wishes from St Francis Xavier U  Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Xavier" wrote in message ... Nevermind, I got it working now. Thanks for suggesting XY scatter. I played around with it a little more and was finally able to alter the starting point. Thank you! Xavier "Bernard Liengme" wrote in message ... Are you making a LINE or XY chart? Should be the latter.  Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Xavier" wrote in message .. . Hi there, I'm trying to plot an exponential smoothing line chart with xvalues from 1 to 20. There are two series, the original data points and the smoothed data points. The problem with this is that the starting point is different. For the original data points (series1), the first value starts at 1 and goes to 20. For the smoothed data points (series2), the first value starts at 2 and goes to 20. When I try to chart the line graph in Excel 2003 by selecting the yvalues for series2 starting at x=2, the chart actually begins at x=1. I was just wondering if anyone knows how to change the starting point for a series in a line graph (if possible). Thank you! Xavier 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Excel Charts  Time line for random points on X axis  Excel Worksheet Functions  
Excel 2003 xy chart  problem plotting more than 330 points  Charts and Charting in Excel  
Secondary Axis Match Primary Axis Gridlines  Charts and Charting in Excel  
space between y axis and data points..  Charts and Charting in Excel  
Secondary Axis Without Data Points?  Charts and Charting in Excel 