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).
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.