short description: the correct point on the graph is selected but the call out seems to be a previous point/date.
I have a line graph. when I select the last point it corresponds to 3/29. when I manually add a call out it properly shows 3/29. But when I try and use vba, the correct point on the graph will be selected but the call out says 3/25.
code that selects the 3/29 date on the graph and puts 3/25 as the call out
this is a photo of the selected point is added with the vba. it selects the point that relates to row 751 and that has a date of 3/29...this is the correct point. the 8.2% that you see on the floating popup showing point 742 is the correct value that goes with 3/29
if I was to manually add the call out, it shows up like this. this is what it should look like
but when I let the rest of the code run, it gives me this call out. the code is picking a prior date for the callout
I have a line graph. when I select the last point it corresponds to 3/29. when I manually add a call out it properly shows 3/29. But when I try and use vba, the correct point on the graph will be selected but the call out says 3/25.
code that selects the 3/29 date on the graph and puts 3/25 as the call out
VBA Code:
ActiveSheet.ChartObjects("Chart 4").Activate
ActiveChart.FullSeriesCollection(7).Points(742).Select
ActiveChart.SetElement (msoElementDataLabelCallout)
this is a photo of the selected point is added with the vba. it selects the point that relates to row 751 and that has a date of 3/29...this is the correct point. the 8.2% that you see on the floating popup showing point 742 is the correct value that goes with 3/29
if I was to manually add the call out, it shows up like this. this is what it should look like
but when I let the rest of the code run, it gives me this call out. the code is picking a prior date for the callout