View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Stuart Stuart is offline
external usenet poster
 
Posts: 62
Default Text boxes and arrows on charts help

Hi,

I hope my description for what I'm trying to do is clear and easy to help
with.

I have a scatter plot and for some of the datapoints I would like to put
text boxes on the chart to comment on important features of the data and
arrows pointing from the text boxes to the relevant datapoints to which they
are referring to. However, the chart will have additional data appended to it
on many occasions in the future, which would grow the x and y axes.

How can I make the text boxes and arrows move, for when the extra data is
added, so that they always point/indicate the required datapoints? I don't
want to have to keep moving text boxes and arrows manually each time.

Thanks.