test to see if callout is on a graph

[smak]

I have callouts on graphs. my full code will delete the existing one and add a new one.

but some of my starting graphs dont have existing call outs. this is causing an error in my code when I try to delete the existing callout (before I add the new one).

Please help me get the code right to delete the existing one if it exists...if it does not just go to the next step. I also tried iserror instead of the isempty but got errors on both

If IsEmpty(ActiveChart.FullSeriesCollection(7).DataLabels.Select) = False Then
        ActiveChart.FullSeriesCollection(7).DataLabels.Select
        Selection.Delete
    End If

 

[RoryA]

You should be able to use something like

If ActiveChart.FullSeriesCollection(7).HasDatalabels then ActiveChart.FullSeriesCollection(7).Datalabels.Delete

 

[smak]

it is not picking up when there is a data label. it seems to think that the charts dont have the label even though I can see it.

 

[smak]

I did not get the previously mentioned methods to work. but I did find a work around. I just let it see if there was an error on the "delete" command line. I understand there may be other ways to solve this but wanted to share my solution for anyone looking at the same issue.

On Error Resume Next
ActiveChart.FullSeriesCollection(7).DataLabels.Delete