G
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?
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?