Hi people,
To freeze a filtered XYScatter chart based on a table, I have the simple code underneath, which does the trick for the data.
I do not want to create an image of the chart, to keep formatting options available.
However, I would like to freeze the datalabel information as well, to prevent an erroneous reference to the table after releasing the filter.
To create datalabels, I use:
But I cannot figure out a way to freeze the datalabel information (in a similar manner).
Could you help me out?
Thanks in advance!
Bookmarks