software

My problem is that I set up my graphs ahead of time and select the whole
range where the data is eventually filled in. When I look at the graph until
the range is full of data the graph doesn't act as a scatter graph. The X
value starts at 1 and increases linearly from there. The graph looks the
same but it is skewed and doesn't reflect the x values correctly. Is there
any fix to this?

Thanks
Steve

You are probably creating a line chart. Even though the Line Chart looks
similar to the XY Scatter Chart, they are very different beasts. You want
the latter.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article gt;, SMArcher221
@discussions.microsoft.com says...
gt; My problem is that I set up my graphs ahead of time and select the whole
gt; range where the data is eventually filled in. When I look at the graph until
gt; the range is full of data the graph doesn't act as a scatter graph. The X
gt; value starts at 1 and increases linearly from there. The graph looks the
gt; same but it is skewed and doesn't reflect the x values correctly. Is there
gt; any fix to this?
gt;
gt; Thanks
gt; Steve
gt;

Thanks for the response. I know the difference between line and scatter and
i have chosen scatter. The graph shows correct x values once the range
selection is filled. I can also fix this problem when I increase the
selection for the graph daily. However I have the document shared and the
graph is not able to be changed in that mode.
Example
X -1 0 1 2 X 1 2 3 4
Y 2 3 4 2 is shown as Y 2 3 4 2
The y values are correct but they don't follow the x value. It is the first
point that is selected and the y value. Then the second point and hte y
value.
Thanks for the response though
Steve

quot;Tushar Mehtaquot; wrote:

gt; You are probably creating a line chart. Even though the Line Chart looks
gt; similar to the XY Scatter Chart, they are very different beasts. You want
gt; the latter.
gt;
gt; --
gt; Regards,
gt;
gt; Tushar Mehta
gt; www.tushar-mehta.com
gt; Excel, PowerPoint, and VBA add-ins, tutorials
gt; Custom MS Office productivity solutions
gt;
gt; In article gt;, SMArcher221
gt; @discussions.microsoft.com says...
gt; gt; My problem is that I set up my graphs ahead of time and select the whole
gt; gt; range where the data is eventually filled in. When I look at the graph until
gt; gt; the range is full of data the graph doesn't act as a scatter graph. The X
gt; gt; value starts at 1 and increases linearly from there. The graph looks the
gt; gt; same but it is skewed and doesn't reflect the x values correctly. Is there
gt; gt; any fix to this?
gt; gt;
gt; gt; Thanks
gt; gt; Steve
gt; gt;
gt;

Steve -

When constructing an XY (Scatter) chart, if any of the worksheet cells for
the X data are interpreted as text instead of numbers, Excel uses the values
1,2,3,... for the X axis.

There are various solutions. One way that may coerce the data from text to
numbers is to enter 0 (zero) in an unused cell, copy, select the X data,
paste special values add.

- Mike
www.mikemiddleton.com

quot;SMArcher221quot; gt; wrote in message
...
gt; Thanks for the response. I know the difference between line and scatter
gt; and
gt; i have chosen scatter. The graph shows correct x values once the range
gt; selection is filled. I can also fix this problem when I increase the
gt; selection for the graph daily. However I have the document shared and the
gt; graph is not able to be changed in that mode.
gt; Example
gt; X -1 0 1 2 X 1 2 3 4
gt; Y 2 3 4 2 is shown as Y 2 3 4 2
gt; The y values are correct but they don't follow the x value. It is the
gt; first
gt; point that is selected and the y value. Then the second point and hte y
gt; value.
gt; Thanks for the response though
gt; Steve
gt;
gt; quot;Tushar Mehtaquot; wrote:
gt;
gt;gt; You are probably creating a line chart. Even though the Line Chart looks
gt;gt; similar to the XY Scatter Chart, they are very different beasts. You
gt;gt; want
gt;gt; the latter.
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt;
gt;gt; Tushar Mehta
gt;gt; www.tushar-mehta.com
gt;gt; Excel, PowerPoint, and VBA add-ins, tutorials
gt;gt; Custom MS Office productivity solutions
gt;gt;
gt;gt; In article gt;,
gt;gt; SMArcher221
gt;gt; @discussions.microsoft.com says...
gt;gt; gt; My problem is that I set up my graphs ahead of time and select the
gt;gt; gt; whole
gt;gt; gt; range where the data is eventually filled in. When I look at the graph
gt;gt; gt; until
gt;gt; gt; the range is full of data the graph doesn't act as a scatter graph.
gt;gt; gt; The X
gt;gt; gt; value starts at 1 and increases linearly from there. The graph looks
gt;gt; gt; the
gt;gt; gt; same but it is skewed and doesn't reflect the x values correctly. Is
gt;gt; gt; there
gt;gt; gt; any fix to this?
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt; Steve
gt;gt; gt;
gt;gt;