Dynamic Chart Data points

[nzas]

Hello
I have a dynamic chart that I want to add a text box that as data is add and chart updates that the text box moves with that data point
eg text box to be added to comment on the 6th data point. as new data is added the text box will be at that point.
If I add 3 more data points the text box i placed the 6th e data point would now be move along the chart with the original data point it was dded to. or be able to add text at data point and move with that point
Hope this can be understood and I can get some help.
See attachment. Hope this is available
Thanks

[Glenn Kennedy]

This is an Excel Forum. An Excel sheet as an attachment would be a little more helpful than a word document!!

[nzas]

Have updated with a file the original file was to show what I was looking for
NZAS

[MrShorty]

I almost always use Rob Bovey's free XY chart labeler add-in for this sort of thing (www.appspro.com ).

[Andy Pope]

You can add a dummy series to the chart that is on the secondary axis.
You can then change the secondary horizontal axis labels to use a dynamic range containing text.
Show data labels with category information.
Format axis so no text is displayed.

[nzas]

Thanks Andy,
This is what I wanted.
Cheers NZAS

[nzas]

Mr Shorty
This did not work see Andy Pope reply his has worked for me. I have use these before

[Andy Pope]

This will explain why and how to get around linked labels and filtered data.
http://www.andypope.info/ngs/ng57.htm