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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top