By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,679 Members | 2,602 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,679 IT Pros & Developers. It's quick & easy.

Excel Chart SeriesCollection Error

P: n/a
Hi all. I am having a bit of a problem with my Perl script and the
creation of a chart. I can create the chart and create a new
SeriesCollection. I then specify the XValues and the Values parameter
of the first SeriesCollection object. I add another SeriesCollection,
but I am only able to set the XValues and I get the following error
when I try to set the Values parameter:

OLE exception from "Microsoft Office Excel":

Unable to set the Values property of the Series class

Win32::OLE(0.1701) error 0x80020009: "Exception occurred"
in PROPERTYPUT "Values" at winprocgraph.pl line 101

Here is the snippet of code that is causing me this headache:

#$chart - chart object
#$xls - workbook object
#$worksheet - worksheet object

$chart = $xls->Charts->Add();
$chart->SetSourceData({Source=>$worksheet->Range("A1")});
$chart->{ChartType} = xlXYScatter;

$chart->SeriesCollection->NewSeries();
$chart->SeriesCollection->NewSeries();
#this series gets added correctly
$chart->SeriesCollection(1)->{XValues} = "='LOGIC'!R2C1:R231C1";
$chart->SeriesCollection(1)->{Values} = "='LOGIC'!R2C2:R231C2";
#only the XValues is added correctly here
$chart->SeriesCollection(2)->{XValues} = "='LOGIC'!R2C3:R231C3";
$chart->SeriesCollection(2)->{Values} = "='LOGIC'!R2C4:R231C4";

$chart->Location({Where=>xlLocationAsObject, Name=>"GRAPH"});

Any help would be greatly appreciated. I have been searching online
for examples to try and see what I am doing wrong, and so far it looks
correct to me. Thanks in advance.

Brian
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: 1
Hi all. I am having a bit of a problem with my Perl script and the
creation of a chart. I can create the chart and create a new
SeriesCollection. I then specify the XValues and the Values parameter
of the first SeriesCollection object. I add another SeriesCollection,
but I am only able to set the XValues and I get the following error
when I try to set the Values parameter:

OLE exception from "Microsoft Office Excel":

Unable to set the Values property of the Series class

Win32::OLE(0.1701) error 0x80020009: "Exception occurred"
in PROPERTYPUT "Values" at winprocgraph.pl line 101

Here is the snippet of code that is causing me this headache:

#$chart - chart object
#$xls - workbook object
#$worksheet - worksheet object

$chart = $xls->Charts->Add();
$chart->SetSourceData({Source=>$worksheet->Range("A1")});
$chart->{ChartType} = xlXYScatter;

$chart->SeriesCollection->NewSeries();
$chart->SeriesCollection->NewSeries();
#this series gets added correctly
$chart->SeriesCollection(1)->{XValues} = "='LOGIC'!R2C1:R231C1";
$chart->SeriesCollection(1)->{Values} = "='LOGIC'!R2C2:R231C2";
#only the XValues is added correctly here
$chart->SeriesCollection(2)->{XValues} = "='LOGIC'!R2C3:R231C3";
$chart->SeriesCollection(2)->{Values} = "='LOGIC'!R2C4:R231C4";

$chart->Location({Where=>xlLocationAsObject, Name=>"GRAPH"});

Any help would be greatly appreciated. I have been searching online
for examples to try and see what I am doing wrong, and so far it looks
correct to me. Thanks in advance.

Brian
Hi Brian, If you ever received a reply or found an answer to your question I would be pleased to hear about it. cheers. shamus
Jul 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.