View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
art art is offline
external usenet poster
 
Posts: 22
Default Reversing the order of a chart

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