in reply to Win32::OLE and Excel Charts

Does your VB macro work, in the sense of changing the color?

If yes, then Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks).

If no, then you will have to read the MSDN Microsoft Office Object Model and find out how to change the color in a Chart series.

If you're asking about whether Excel can change the colour of a chart series - this is Perlmonks, not Excelmonks.

Replies are listed 'Best First'.
Re^2: Win32::OLE and Excel Charts
by kslov75 (Initiate) on Jun 09, 2011 at 17:13 UTC

    Corion, Thanks for the reply. The VB Macro is not showing the VB code to change the color. I will look at the MSDN documentation to see...

[reply]

In Section Seekers of Perl Wisdom