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