|Just another Perl shrine|
Re^5: Excel and Win32::OLE chart problemsby lvleph (Initiate)
|on Jul 18, 2008 at 20:13 UTC||Need Help??|
I am having a similar problem. I need to add multiple series to one chart and so I don't believe I can use the ChartWizard.
Currently, I use the following code to add a series:
This however does not set the XValues, which I try to do with the following code:
$Range = $Sheet3->Range("C$num2:C$num1");
This results in the following error:
Win32::OLE(0.1709) error 0x80020011: "Does not support a collection"
in METHOD/PROPERTYGET "XValues" at ./PollenAVG.pl line 149
Any Ideas? Thank you in advance.