TSeriesDataXLS exporting to multiple xls worksheets

[neo]

Hi,

I'm just wondering if supports exists for exporting to multiple xls worksheets. I have multiple line series on a single chart and would like to have each x-y pair on their own worksheet. If this is possible could someone help me figure it out.

Alternatively, can I export data in a 2 dimensional layout where the X values appear in only the first column and the Y values for all line series appear in subsequent columns. The reason I want to do this is because the X values remain constant across all the line series'. Only the Y values change.

Thanks so much.

Cheers,
neo

[Yeray]

Hi neo,

You can export you chart as an xls but I'm afraid not multiple charts into multiple worksheets.
However, you may be able to find some way in the net to be able to edit an Excell file in Delphi.