View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Locking object to data points

Hi,

Create another series where you use custom markers to hold the arrows.
http://peltiertech.com/Excel/Charts/PointAtPoints.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"CheriC" wrote in message
...
How can I lock an arrow & text to a particular data point? In a time
series
graph, every time I add new dates, currently the arrows pointing to
particular data points for particular dates have to be moved manually.