Control the Series Sorting of 10 bar charts?

Hello,

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

Thanks alot in advance!!

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


"Bigbenjam" <Bigbenjam.1yzxzm_1132827902.4919@excelforum-nospam.com> wrote
in message news:Bigbenjam.1yzxzm_1132827902.4919@excelforum-nospam.com...
>
> Hello,
>
> I just tried to create a bar chart for 5 series and 10 diffent datasets
> and a individual series sorting for each data set. But after hours of
> frustration I finally gave that up and create 10! different bar charts
> each with one dataset where I could set the series sorting
> independently. My simple question is now, how can I change the series
> sorting with VBA? I have a Sheet called "sorted diagramm" and there are
> 10 different charts on it. Now how do I get hold off those charts? I
> don't now how to do this with vba. I think after that it should be
> simple, there ought to be a series property in the chartarea object
> somewhere, right?
>
> Thanks alot in advance!!
>
>
> --
> Bigbenjam
> ------------------------------------------------------------------------
> Bigbenjam's Profile:
> http://www.excelforum.com/member.php...o&userid=29062
> View this thread: http://www.excelforum.com/showthread...hreadid=487894
>