Board index » delphi » Setting XValues for SeriesCollections
peter worbis
Delphi Developer |
Setting XValues for SeriesCollections2005-03-03 07:04:15 PM delphi126 Hi all, I'm trying to create a chart in Excel. But whenever I try to set a range for a series I am getting the following error message "Die XValues-Eigenschaft des Series-Objektes kann nicht festgelegt werden" / "The xvalues property of the series object could not be defined" ??? Here is the code I am using. xChart := xXL.Charts.Add; xChart.ChartType := xlXYScatterLines; xNewSeries := xChart.SeriesCollection.NewSeries; xNewSeries.Name := 'Series 1'; xNewSeries.XValues := '=Daten!A5:A100'; // <-- here the error occurs xNewSeries.Values := '=Daten!B5:B100'; I've tried early binding, late binding and the Delphi server components but the result is always the same. Any help appreciated, Thanks in advance Peter |