Assigning a comment to an entry in a dynamic chart

[Ironman]

Hi

I have a dynamic chart showing the last 90 days' entries and there are one or two spikes in the data that I want to comment on.

Right now, the text box I added is fixed to where I inserted it in the chart so when the next entry is added it's out of position and therefore meaningless.

Is it possible for text boxes to be assigned to certain entries so they 'move' with the entry, to eventually drop out of the chart when 90 days have expired?

Or is there an easier method of adding/assigning comments I haven't considered?

Many thanks!

 

[pgc01]

Hi

You can use the point datalabel.

 

[Ironman]

Hey that's brilliant pgc01, many thanks - I'd ignored that as I thought it had something to do with decimal points.

 

[pgc01]

You're welcome. Thanks for the feedback.