View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Can I fix a text box to a chart data point?

You can link data labels to cells.
Either of these two free addins will help with the task.

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Phil" wrote in message
...
Andy,
Thanks for your response, but I don't see any way to add a text label.
The options are for values only. What I need is a way to add a text box
that
says somthing like "Bought new scale" and have that text box stay with a
date
on the horizontal scale that changes as I add new weights daily.

"Andy Pope" wrote:

Hi,

If you have used an embedded shape to hold the text you will need to use
VBA
to adjust the position when more data is added.
To have text move automatically you would need to use data label(s).

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Phil" wrote in message
...
I have a daily weight chart. I need to add events text boxes on the
chart.
I
wish to fix the boxes to data points and have them track the points so
when
new data is added, the text box follows the data point.