Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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).

2 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks a lot for your suggestion.

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