How Do I 'Lock' My Chart?

[Guest]

I have my Excel data tables in 'list' format. I sort a category in descending
order and make a quick Pareto chart. I sort by another column to make another
chart, and the first chart I made is resorted as well. Is there a 'lock'
function for charts, or do I perhaps have to do a Copy/Paste Special to
unlink the chart from the original data like you do to remove cell formulas?

 

[Andy Pope]

Hi,

Jon Peltier has some information on de-linking chart data.
http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html

Cheers
Andy