Re: Re: Re: Trouble adding a secondary Axis to an Excel chart

Yes so you will need to know how it is done in VB.....because this is how you will do it using Win32::OLE and the chances of you finding VB code to do X on windows are high. The chances of finding an example in Perl using OLE is much lower.

cheers

tachyon

s&&rsenoyhcatreve&&&s&n.+t&"$'$`$\"$\&"&ee&&y&srve&&d&&print

Comment on Re: Re: Re: Trouble adding a secondary Axis to an Excel chart

Replies are listed 'Best First'.
Re: Re: Re: Re: Trouble adding a secondary Axis to an Excel chart by bshaner (Initiate) on Sep 26, 2003 at 06:52 UTC
I think I am getting closer. In VB the command is `Charts("Chart1").HasAxis(xlValue, xlPrimary) = True` After some more digging in the Win32::OLE documentation I can turn the primary axis on and off with `$Chart->SetProperty('HasAxis', xlValue, xlPrimary , 'True');` When I change to the xlSecondary axis the command runs without error but the axis does not turn on. Very puzzling. Back to digging. Thanks for your help.	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re: Re: Re: Re: Trouble adding a secondary Axis to an Excel chart
by bshaner (Initiate) on Sep 26, 2003 at 06:52 UTC

Charts("Chart1").HasAxis(xlValue, xlPrimary) = True

$Chart->SetProperty('HasAxis', xlValue, xlPrimary , 'True');

[reply]
[d/l]
[select]