Delink Chart

Series - press F9 in the Formula Bar

VBA - for each series
myseries.XValues = myseries.XValues
myseries.Values = myseries.Values
myseries.Name = myseries.Name

peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html