On Mar 22, 4:06*pm, "Jon Peltier"
wrote:
That's what Andy was referring to, by "calculating their position".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.http://PeltierTech.com/WordPress/
_______

"Pete" wrote in message

...
On Mar 22, 11:57 am, Andy Pope wrote:





Hi,

Textboxes by themselves will not track your monthly data. For that you
would need to use data labels.
To update the textboxes would require VBA code to calculate there
position in relation to the chart and the data.

Cheers
Andy

Pete wrote:
I have some charts that are annotated with Text Boxes that line up
with that Months data. If I add extra months to the Chart then I have
to move all the Text boxes along a little to the left to remain
matched up with the Data it corresponds to, can this be automatically
done?

Thanks

Pete

--

Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info

Andy,
I think I've misled you. I don't want to update the Text in the Text
Boxes I just want them to remain lined up with the Month that they
correspond to when extend the Range of the Source Data for the Chart.- Hide quoted text -

- Show quoted text -

Hi,

Don't suppose you could give an example of the code required or know
where there is an example. VBA is not my strong point.

Thanks

Peter