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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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/
_______
 
Back
Top