Hi all,
I've got a chart where i've placed a few text boxes and arrows and have then grouped it which is fine. It's really problematic whenever i update my chart.
As you can imagine, my chart 'shifts' along when new data is added but the arrows and text boxes are now in the wrong places. So basically my question is: is there an excel feature that sets the properties of these arrows and text boxes in relative terms?? if not, do you think i could do this programmatically using VBA? Any pointers would be highly appreciated!
best.
e
I've got a chart where i've placed a few text boxes and arrows and have then grouped it which is fine. It's really problematic whenever i update my chart.
As you can imagine, my chart 'shifts' along when new data is added but the arrows and text boxes are now in the wrong places. So basically my question is: is there an excel feature that sets the properties of these arrows and text boxes in relative terms?? if not, do you think i could do this programmatically using VBA? Any pointers would be highly appreciated!
best.
e