Hi Kirk,
Let pivot tables do the work for you. Build a pivot Chart with a row field
that has advancedc options set to show top ten. Use a page field to
choose different columns.
Ed Ferrero
http://edferrero.m6.net/
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