Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sort a data without affecting the scatter chart
Hi,
I have a have pair of (x,y) values in a big 2 columnrange and I have made a scatter chart from,only part of this range.(say from last 20 values) Values in x column are sorted when i made the chart ,but when i sort the data from y values now,my scatter chart goes for a toss and sorting the data completely disfigures the chart. (as there are new (x,y ) values now in the range from which i made the range). How can i sort the my data without affecting the scatter chart? Thanks, Piyush |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sort a data without affecting the scatter chart
Piyush -
In Excel 2003 and earlier versions, do not use the AZ or ZA icons on the standard toolbar. Instead, select the two-column range, and choose Data | Sort. In Excel 2007, select the range, and choose Home | (Editing) Sort & Filter | Custom Sort. - Mike http://www.MikeMiddleton.com "Piyush" wrote in message ... Hi, I have a have pair of (x,y) values in a big 2 columnrange and I have made a scatter chart from,only part of this range.(say from last 20 values) Values in x column are sorted when i made the chart ,but when i sort the data from y values now,my scatter chart goes for a toss and sorting the data completely disfigures the chart. (as there are new (x,y ) values now in the range from which i made the range). How can i sort the my data without affecting the scatter chart? Thanks, Piyush |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I'd like to Sort one column without affecting the others | Excel Worksheet Functions | |||
chart type affecting data order | Charts and Charting in Excel | |||
How can I sort data without affecting formula? | Excel Discussion (Misc queries) | |||
sort worksheet without affecting workbook | Excel Worksheet Functions | |||
Scatter Chart data | Charts and Charting in Excel |