Reversing the order of a chart

A

Art

H
I have a line chart with 10 data series in it. I would like to reverse the order of the series. Is there an easy way to do this

An example: the data goes from 1, 2, 3, 4, to 10. I would like it to go from 10, 9, 8, to 1

I thought that I had seen something on reversing parts of a chart. The only thing that I found was Axes(xlvalue).ReversePlotOrder, and that didn't do what I wanted it to do. I could change the code for the way that it picks up the data, but I thought there was an easier way to do this

Thanks

Art
 
J

Jon Peltier

Art -

Seems to easy to be true:

Sub ReverseSeriesOrder()
Dim i As Long
For i = 1 To ActiveChart.SeriesCollection.Count
ActiveChart.SeriesCollection(i).PlotOrder = 1
Next
End Sub


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

Art

Hi Jo

That worked great, but I guess I wasn't clear enough. I was wanting to change the order of the category axis. Any other suggestions

Thanks again

Ar

----- Jon Peltier wrote: ----

Art

Seems to easy to be true

Sub ReverseSeriesOrder(
Dim i As Lon
For i = 1 To ActiveChart.SeriesCollection.Coun
ActiveChart.SeriesCollection(i).PlotOrder =
Nex
End Su


- Jo
------
Jon Peltier, Microsoft Excel MV
Peltier Technical Service
Tutorials and Custom Solution
http://PeltierTech.com
______

Art wrote
 
Top