Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
When you export a chart to excel by default headers are added .... from where do you export?
Hi,
Chart Window title Caption need. Alessandro. i was wrongly mentioned header.
Then you have to write a macro. Search the forum for it, there is a lot of examples.
You cannot export the Caption, I have tried this before
You could create a text object and make it look similar to the Caption, but you cannot export the Caption
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.
Hi Jerry,
Post some sample macro for my requirement.
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
Hey Mathew,
You can use the below macro.
Credits to Ravi Kumar.
How to export to Excel include Title Caption?
Cheers,
Naresh