How Do I 'Lock' My Chart?
 

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?

How Do I 'Lock' My Chart?
 

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"archsmooth" wrote in message
...
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?