View Single Post
  #1   Report Post  
Kirk
 
Posts: n/a
Default Filtering and Charts

Hi,

I have a whole lot of columns each that I want to graph top ten values for.
When I Auto Filter and then bring up the top ten values for a particular
column, I can get the top ten on a chart. When I want to chart the top ten
for another column I have to change the filtering and this in turn changes
the already created chart. Is there any way that I can prevent this from
happening?

Thanks for your time