View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
archsmooth archsmooth is offline
external usenet poster
 
Posts: 17
Default 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?