Export to excel with chart header.

[muniyandi]

Hi,

In my chart export to excel, i need chart header line also in excel result.

any one know the answer kindly post. it's achieve in macro is possible ?

Thanks,

Muni.

[alexandros17]

When you export a chart to excel by default headers are added .... from where do you export?

[muniyandi]

Hi,

Chart Window title Caption need. Alessandro. i was wrongly mentioned header.

[jerrysvensson]

Then you have to write a macro. Search the forum for it, there is a lot of examples.

[rustyfishbones]

You cannot export the Caption, I have tried this before

[rustyfishbones]

You could create a text object and make it look similar to the Caption, but you cannot export the Caption

[alexandros17]

I'm sorry but I disagree, you may export the Caption of a chart and its content as xls by macro.

Look for it in forum.

[muniyandi]

Hi Jerry,

Post some sample macro for my requirement.

[rustyfishbones]

Hi Alessandro,

If you find it please share, I looked for this requirement extensively a few months ago and I could not export the Caption nor could I find the answer in the forum

Regards

Alan

[NareshGuntur]

Hey Mathew,

You can use the below macro.

Credits to Ravi Kumar.

How to export to Excel include Title Caption?

Cheers,

Naresh