I need to break the links in a chart that has a data table. Breaking the link is simple. The code to break all the links is simply:
Sub BreakChartLinks()
For Each x In ActiveChart.SeriesCollection
x.Values = x.Values
x.XValues = x.XValues
x.Name = x.Name
Next x
End Sub
The issue is...