Page 1 of 1

Export Excel: Series Names

Posted: Mon Dec 13, 2010 9:29 am
by 15054354
Hi,

When exporting chart in XLS format, Series Names does not appear, it just indicates "Y".

Export in XLS format:
excel_export.png
excel_export.png (9.05 KiB) Viewed 5852 times


As you can see, Export in TXT format include Series Names. But this export doeas not work for me , because it exports all Null values( xls exports empty cells).
text_export.png
text_export.png (10.9 KiB) Viewed 5865 times

How can I get Series Names in XLS export?

Thanks,
Petar

Re: Export Excel: Series Names

Posted: Tue Dec 14, 2010 1:18 pm
by yeray
Hi Petar,

You have to set the Name property of the lists exported:

Code: Select all

    TChart1.Series(0).XValues.Name = "AA"
    TChart1.Series(0).YValues.Name = "BB"

Re: Export Excel: Series Names

Posted: Tue Dec 14, 2010 2:21 pm
by 15054354
Thanks a lot Yeray.

Petar