Keeping text boxes aligned to data points on a chart

[futbuk]

I have a standard chart (Dates across bottom data above).Every now and then I add comment boxes with arrows pointing to a specific data point on the chart. Each day when I enter new data to the chart my text boxes (and arrows) get misaligned (due to the addition of new data). Does anyone know of any way to keep the arrows and text boxes aligned with the specific data points on my chart? I would not be adverse to changing around my data base in some manner if I could actually get it to plot text next to a specific data point but have not been able to figure that out either....

 

[SkipVought]

Hi,

Excel has no native functionality for this issue. However it can be accomplished via VBA.

Please post in VBA Visual Basic for Applications (Microsoft) forum707.

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[byundt]

Take a look at Rob Bovey's XY Labeler add-in for charts. It attaches a textbox taken from a worksheet range and attaches it to data points, and the textbox moves with the data. It is a free download at

http://www.appspro.com/Utilities/ChartLabeler.htm

Brad