View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bigbenjam Bigbenjam is offline
external usenet poster
 
Posts: 1
Default 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