 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
10-07-2005, 05:05 PM
|
|||
|
|||
|
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 
|
|
#2
10-07-2005, 06:05 PM
|
|||
|
|||
|
Re: H2 insert a text tag into a line graph
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
|
|
#3
10-09-2005, 10:05 AM
|
|||
|
|||
|
Re: H2 insert a text tag into a line graph
Andy, thanks for the help. I'll try these out.
Cheers Colin "Andy Pope" <andy@andypope.info> wrote in message news:eVytpF4yFHA.3812@TK2MSFTNGP09.phx.gbl... > 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
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
