I have a chart driven by data placed in a sheet using some VBA code. The chart includes a data label that picks up the content of a cell where the label is created by the same VBA code.
The lines on the chart update when the inputs are changed and the code is run but the data label on one point, used to flag a key point on the curve, remains locked at the text it contained when the data series was formatted using the Select Data dialog.
The following code is used to force an update at the end of the VBA run and works on the numerical parts of the graph.
Application.Calculation = xlCalculationAutomatic
A snapshot of the graph is attached.
The vertical line on the graph is in the right place as is a single point, which has no marker, that I place above the top of the line. The label is attached to the single point but it isn't changing even though the contents of the cell it refers to have changed. Labelling-bug.docx
How can I force the label to update? I can't even do it manually without removing the label and remaking it.