View Single Post
  #2   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?

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.