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

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?

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

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)


"asg2307" wrote:

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?

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

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

"john" wrote:

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)


"asg2307" wrote:

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?