software

Why does the way a spread sheet is sorted change the look of a scatter plot
graph??? the graph is just a plot of two points, (X, Y) and these two points
are definded by two collumns for a given row. The two collumns don't change,
and the row all stays together, so why does it change where points are
plotted out on the graph when you re-sort it?

AndrewT420 -

Usually, for an XY (Scatter) chart, with values of X in a column and
corresponding values of Y in an adjacent column, for three or more points,
Excel assumes (correctly) quot;Series in Columns.quot;

But, when you have only two X,Y pairs, Excel assumes (usually incorrectly
for most users) quot;Series in Rows.quot;

You can check this by selecting the chart (or some object of the chart) and
choosing Chart | Source Data | Data Range.

- Mike
www.mikemiddleton.com

quot;AndrewT420quot; gt; wrote in message
...
gt; Why does the way a spread sheet is sorted change the look of a scatter
gt; plot
gt; graph??? the graph is just a plot of two points, (X, Y) and these two
gt; points
gt; are definded by two collumns for a given row. The two collumns don't
gt; change,
gt; and the row all stays together, so why does it change where points are
gt; plotted out on the graph when you re-sort it?