Control the Series Sorting of 10 bar charts?
 

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!

--
Bigbenja
-----------------------------------------------------------------------
Bigbenjam's Profile: http://www.excelforum.com/member.php...fo&userid=2906
View this thread: http://www.excelforum.com/showthread.php?threadid=48789

Control the Series Sorting of 10 bar charts?
 

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" wrote
in message ...

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