H2 insert a text tag into a line graph

Hi, can anyone help me???
I'd like to tag different points on a line graph with a text box or text to
show where something has changed or just to record something specific to the
point. i've tried adding a text box but it won't move with the data point if
I add more points.

Any suggestions greatly appreciated...

Thanks

colin

Hi,

Depending on the amount of text you could add a dummy data series and
use its data labels to hold the text. Data labels can be linked to cells
or you can manually enter text into the data label. Select the data
labels and the select a specific one. Now in the formula bar either type
the relevant text or to link to a cell enter the cell reference
including the sheet name.
The are also a couple of free addin for linking labels to cells.

Rob Bovey's Chart Labeler (http://appspro.com)
John Walkenbach's Chart Tools (http://j-walk.com)

Cheers
Andy

Colin Chisholm wrote:
> Hi, can anyone help me???
> I'd like to tag different points on a line graph with a text box or text to
> show where something has changed or just to record something specific to the
> point. i've tried adding a text box but it won't move with the data point if
> I add more points.
>
> Any suggestions greatly appreciated...
>
> Thanks
>
> colin
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy, thanks for the help. I'll try these out.

Cheers
Colin

"Andy Pope" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> Depending on the amount of text you could add a dummy data series and use
> its data labels to hold the text. Data labels can be linked to cells or
> you can manually enter text into the data label. Select the data labels
> and the select a specific one. Now in the formula bar either type the
> relevant text or to link to a cell enter the cell reference including the
> sheet name.
> The are also a couple of free addin for linking labels to cells.
>
> Rob Bovey's Chart Labeler (http://appspro.com)
> John Walkenbach's Chart Tools (http://j-walk.com)
>
> Cheers
> Andy
>
> Colin Chisholm wrote:
>> Hi, can anyone help me???
>> I'd like to tag different points on a line graph with a text box or text
>> to show where something has changed or just to record something specific
>> to the point. i've tried adding a text box but it won't move with the
>> data point if I add more points.
>>
>> Any suggestions greatly appreciated...
>>
>> Thanks
>>
>> colin
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info