Does anyone know how to add additional series to an excel chart.
I have created the chart in excel using the progress 4gl and all works fine with a single series, but when I attempt to specify the source for a second data series I run into problems.
I have added a second series using:
vchChart:SeriesCollection:NewSeries.
and then attempt to add the source by:
vchChart:SeriesCollection(2):VALUES(vchWorkSheet:Range("C1:C":U + STRING(viCounter)), 2).
Progress claims the syntax is incorrect but as far as I can tell I'm on the right lines.
I have created the chart in excel using the progress 4gl and all works fine with a single series, but when I attempt to specify the source for a second data series I run into problems.
I have added a second series using:
vchChart:SeriesCollection:NewSeries.
and then attempt to add the source by:
vchChart:SeriesCollection(2):VALUES(vchWorkSheet:Range("C1:C":U + STRING(viCounter)), 2).
Progress claims the syntax is incorrect but as far as I can tell I'm on the right lines.