# why does sorting change a scatter plot graph?

=?Utf-8?B?QW5kcmV3VDQyMA==?=
Guest
Posts: n/a

 21st Apr 2006
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?

Mike Middleton
Guest
Posts: n/a

 21st Apr 2006
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) "Series in Columns."

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

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

"AndrewT420" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post KenN Microsoft Excel Charting 0 12th May 2011 11:21 PM Janet A. Thompson Microsoft Excel Charting 2 1st Apr 2010 06:53 PM Mr. SweatyFinger Microsoft ASP .NET 2 2nd Dec 2006 04:46 PM =?Utf-8?B?YmFuZGVyc29u?= Microsoft Excel Programming 3 5th Feb 2005 04:42 AM Jim Microsoft Excel Charting 13 8th Oct 2003 05:10 PM

Features