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

A

asg2307

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

john

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)
 
A

asg2307

Thanks ,this will work and I can see this is a perfect way to use it for
PowerPoint.
 
Top