If it's an XY or Line chart that doesn't already have valid data for the
XValues or Values (such that the series is not plotted), you may get this
problem. Set the series to a column or area type, manipulate the XValues and
Values, then change back to XY or Line.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"sergio" wrote in message
oups.com...
Using Powerbuilder, I get an the following error:
Error accessing external object property xvalues at line 88......
My code is very simple:
ole_excel.Worksheets(l_engine).Activate //Ok
ole_excel.ActiveSheet.ChartObjects(1).Activate //Ok
ole_excel.ActiveChart.ChartTitle.Characters.Text = "Engine " +
string(l_engine) //Ok
ole_excel.ActiveChart.SeriesCollection(1).XValues = "=Engine"+
string(l_engine) + "!R2C1:R2C" + string(l_values) //Error!!!
I have Microsoft Office 2003 Installed in my machine.
Why I could not access XValues of SeriesCollection.
Have tried doing it running a macro in Excel directly with no luck.
Any help would be gladly apreciated.