Getting excel to chart the top 10 of a series

**controlfreak** · 06-18-2009, 09:52 AM

Hi guys,

I've a workbook loaded up that contains Rejection Reasons and the respective percentages of the total. I need excel to dynamically graph the top 10 percentages.

Is this possible?

**Andy Pope** · 06-18-2009, 09:58 AM

Simplest way is to use Autofilter, Top 10.

Or you will need formula, LARGE/MATCH/INDEX, to construct a table of 10 items.

Or use a pivot table/chart

**controlfreak** · 06-18-2009, 10:28 AM

Hey thanks for the reply.

If i use the Autofilter would it be possible to name the range from say cell C2 to C11 and call these 10 figures "Graph". Then when i sort the range will the figues that fall into this named range automatically update on the graph?

**Andy Pope** · 06-18-2009, 10:48 AM

Not with autofilter.

If you sort the data then yes.

If you put this formula in J1 and copy across the range J1:L11

=A1

You can then chart the relevant data from J1:L11

The Sort A1:C46 on column C Descending to get Top 10 %'s