467,915 Members | 1,162 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

Excel Chart SeriesCollection Error

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
  • viewed: 12141
Share:
1 Reply
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.

Similar topics

3 posts views Thread by Kevin Long | last post: by
22 posts views Thread by PeteCresswell | last post: by
1 post views Thread by Randall Arnold | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.