how to send to excel a chart with the caption in qlikview

[marjan_it]

I want to send to excel chart and table with header. is there any way to do this?

I want a macro but I couldnt use it and for that I should add button for each chart.

is there any other help to do this?!!

[avinashelite]

you need to make use of a button or text object which is a easy way to trigger the respective macro

check this thread

Export chart title

[marjan_it]

but by macro we should add for each chart separate, but I want something that act for every chart and table in document!