Control the Series Sorting of 10 bar charts?

[Bigbenjam]

Hello,

I just tried to create a bar chart for 5 series and 10 diffent dataset
and a individual series sorting for each data set. But after hours o
frustration I finally gave that up and create 10! different bar chart
each with one dataset where I could set the series sortin
independently. My simple question is now, how can I change the serie
sorting with VBA? I have a Sheet called "sorted diagramm" and there ar
10 different charts on it. Now how do I get hold off those charts?
don't now how to do this with vba. I think after that it should b
simple, there ought to be a series property in the chartarea objec
somewhere, right?

Thanks alot in advance!

 

[Jon Peltier]

Something like this:

ActiveChart.SeriesCollection("Series 1").PlotOrder = 3

In the VBE, select Object Browser from the View menu. The Object Browser is
a very handy tool to help figure out the object model.

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