Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
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.
Thanks a lot for your suggestion.
I was however looking for a way to achieve this without the use of macros.