how do you change the data order in a graph without modifying the.

[sambre]

how do you change the data order in a graph without modifying the table?

I know it is possible if you change your table, but it is not very convenient.

Thanks

 

[Jon Peltier]

You can change the order of the series: double click a series, then rearrange the
series in the Series Order tab.

If you need to change the left-right order of categories along the X axis of a
chart, you pretty much have to modify the table. If the table is for display, you
could chart from a separate table, both tables linked to the same source data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______