How do I keep my chart from changing when excel has autofilter?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I made a chart while the excel sheet is in autofilter and hide. Is there a
way to lock the chart or prevent its changing when the hidden items are
unhidden. Not sure what will happen with autofilter. Will it do the same
thing? In other words change my graph?
 
click on the chart and hold shift and click edit, and copy then paste as a
picture
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Back
Top