TSeriesDataXLS exporting to multiple xls worksheets
Posted: Wed Sep 22, 2010 5:34 pm
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
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