Export Excel: Series Names

TeeChart for ActiveX, COM and ASP
Post Reply
Petar
Newbie
Newbie
Posts: 40
Joined: Tue Oct 06, 2009 12:00 am

Export Excel: Series Names

Post by Petar » Mon Dec 13, 2010 9:29 am

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 5770 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 5783 times

How can I get Series Names in XLS export?

Thanks,
Petar

Yeray
Site Admin
Site Admin
Posts: 9602
Joined: Tue Dec 05, 2006 12:00 am
Location: Girona, Catalonia
Contact:

Re: Export Excel: Series Names

Post by Yeray » Tue Dec 14, 2010 1:18 pm

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"
Best Regards,
ImageYeray Alonso
Development & Support
Steema Software
Av. Montilivi 33, 17003 Girona, Catalonia (SP)
Image Image Image Image Image Image Please read our Bug Fixing Policy

Petar
Newbie
Newbie
Posts: 40
Joined: Tue Oct 06, 2009 12:00 am

Re: Export Excel: Series Names

Post by Petar » Tue Dec 14, 2010 2:21 pm

Thanks a lot Yeray.

Petar

Post Reply