A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Different Starting Points on X-Axis



 
 
Thread Tools Display Modes
  #1  
Old January 28th, 2006, 07:23 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Different Starting Points on X-Axis

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


  #2  
Old January 28th, 2006, 08:06 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Different Starting Points on X-Axis

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 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



  #3  
Old January 28th, 2006, 08:24 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Different Starting Points on X-Axis

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.

"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 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





  #4  
Old January 28th, 2006, 09:08 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Different Starting Points on X-Axis

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 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





  #5  
Old January 29th, 2006, 10:26 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Different Starting Points on X-Axis

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 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







 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 xy chart - problem plotting more than 330 points ehmcneill Charts and Charting 1 December 17th, 2005 01:18 AM
Line-bar chart on 2 axis George Wilson Charts and Charting 1 September 21st, 2004 03:28 PM
P & V chart: Secondary X axis gradient (again) wlotto Charts and Charting 9 March 15th, 2004 06:26 PM
force graph to axis of choice bbxrider Charts and Charting 2 February 12th, 2004 10:51 PM
force graph to axis of choice Tushar Mehta Charts and Charting 3 February 11th, 2004 05:04 PM


All times are GMT +1. The time now is 06:27 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.