I have a chart which tracks 13 weeks of data. Each week the data in the
table is moved one cell to the left (Copy the right 12 columns and paste
special over the left 12 columns) and add the new weeks data to the very
right column. I have data labels (value) on the points in the chart.
I need to add a comment to a datum point and have this comment move across
the chart from right to left as the datum point does.
I've read and tried some of the suggestions in the discussion which seemed
to fit my situation but they didn't work.