VBA-Line chart colors

E

Edward

Hi Everybody,
Bar chart colores are based on color scheme therefore we have access to them
in VBA ( colorscheme, extracolor, .. methods ) but I couldnt find a way to
set the line chart colors using VBA . any suggestions?
 
E

Edward

Thanks Steve. PP 2003 although I'm going to convert everything into 2007.
Charts could be created in Excel or even in PP itself. In 2007 MS graph is
gone so possibily I just need to know about charts created in Excel.
Thanks.
 
E

Edward

Thanks Steve, acctually I did try to use macro recorder and the only thing it
generated for me was
ActiveWindow.Selection.ShapeRange.OLEFormat.DoVerb Index:=1
because for working with grapgs ( after double clicking on it) we go to a
different screen and apperantly macro recorder doesn't recognize any action
in that view.
I will use your code and do some expierence
It was very helpful as always :)
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top