Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Is it possible to add information on excel export or export the title of a chart?

I have several charts for which an excel export should be possible for the users. However some of them contain confidential data. Now I want to add a pointer to this to the excel export. As far as I can see it doesn't make sense to add the information to the title, because it will not be exported. Are there any other ideas or does the possibility to export the title exist after all (couldn't find anything without the use of macros so far).

Tags (3)
2 Replies
Highlighted

Re: Is it possible to add information on excel export or export the title of a chart?

Yes it's possible, but not without macro's. See attached example. I've modified the file I found here so that it puts the chart title above the chart. You can adapt it to put any text you want there. Or in any other location. Just change the range in objCurrentSheet.Range("A1").Value to something else than A1.

Not applicable

Re: Is it possible to add information on excel export or export the title of a chart?

Thanks a lot for your suggestion.

I was however looking for a way to achieve this without the use of macros.