Formatting DataTable in a Chart when links are broken

[weaverjohn]

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 that the datatable format is now gone. And I have been uable to figure out how to format it Any clues toward a solution would be greatly appreciated.


Thanks

 

[NARAYANK991]

Hi John ,


I tried out your code with a chart and a data table , and I am not facing any problem.


Can you upload your file with some sample data ?


Narayan