software

Hi there,

I'm trying to plot an exponential smoothing line chart with x-values 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 y-values 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
Are you making a LINE or XY chart? Should be the latter.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Xavierquot; gt; wrote in message
.. .
gt; Hi there,
gt;
gt; I'm trying to plot an exponential smoothing line chart with x-values from
gt; 1 to 20. There are two series, the original data points and the smoothed
gt; data points. The problem with this is that the starting point is
gt; different. For the original data points (series1), the first value starts
gt; at 1 and goes to 20. For the smoothed data points (series2), the first
gt; value starts at 2 and goes to 20. When I try to chart the line graph in
gt; Excel 2003 by selecting the y-values for series2 starting at x=2, the
gt; chart actually begins at x=1. I was just wondering if anyone knows how to
gt; change the starting point for a series in a line graph (if possible).
gt; Thank you!
gt;
gt; Xavier
gt;
I've done both, and even when I set the correct x-value range, series 2
always starts at x=1 and goes to x=19.

quot;Bernard Liengmequot; gt; wrote in message
...
gt; Are you making a LINE or XY chart? Should be the latter.
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Xavierquot; gt; wrote in message
gt; .. .
gt;gt; Hi there,
gt;gt;
gt;gt; I'm trying to plot an exponential smoothing line chart with x-values from
gt;gt; 1 to 20. There are two series, the original data points and the smoothed
gt;gt; data points. The problem with this is that the starting point is
gt;gt; different. For the original data points (series1), the first value starts
gt;gt; at 1 and goes to 20. For the smoothed data points (series2), the first
gt;gt; value starts at 2 and goes to 20. When I try to chart the line graph in
gt;gt; Excel 2003 by selecting the y-values for series2 starting at x=2, the
gt;gt; chart actually begins at x=1. I was just wondering if anyone knows how to
gt;gt; change the starting point for a series in a line graph (if possible).
gt;gt; Thank you!
gt;gt;
gt;gt; Xavier
gt;gt;
gt;
gt;
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

quot;Bernard Liengmequot; gt; wrote in message
...
gt; Are you making a LINE or XY chart? Should be the latter.
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Xavierquot; gt; wrote in message
gt; .. .
gt;gt; Hi there,
gt;gt;
gt;gt; I'm trying to plot an exponential smoothing line chart with x-values from
gt;gt; 1 to 20. There are two series, the original data points and the smoothed
gt;gt; data points. The problem with this is that the starting point is
gt;gt; different. For the original data points (series1), the first value starts
gt;gt; at 1 and goes to 20. For the smoothed data points (series2), the first
gt;gt; value starts at 2 and goes to 20. When I try to chart the line graph in
gt;gt; Excel 2003 by selecting the y-values for series2 starting at x=2, the
gt;gt; chart actually begins at x=1. I was just wondering if anyone knows how to
gt;gt; change the starting point for a series in a line graph (if possible).
gt;gt; Thank you!
gt;gt;
gt;gt; Xavier
gt;gt;
gt;
gt;
Thanks for the feedback
Best wishes from St Francis Xavier U
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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