Adding a text/line from Drawbox onto graph

[Marcin Peciak]

Hi,

I have a graph that is being updated weekly, so every time the X-axis
extends.

I add comment texts and / or pointers/lines to the graph from time to time.
The problem I have is that each time I expand the graph (X range increases),
I have to manually move the comments - because the graph is being rescaled.

Is there any way to link the additional elements on the plot to be moved
with the X-scale?

Any suggestions?

Many thanks,
Marcin

 

[Shane Devenshire]

Hi,

Replace the textbox comments with a comment in a Data Label. If you only
want one comment, select the series, then single click the data point closest
to where you want the comment. Choose Format, Data Point, and turn on Value
on the Data Labels tab, click OK.
Single click the data label, and then single click it again. Then type your
comment and press Enter.

Data Labels track the data points which means as you data changes the
comment will travel up and down with the data point.