Chart Presentation Based On Conditional Formatting

[James Perry]

Hello friends......
In worksheet #1 column A i have names of 15 senior sales reps.
In col B are sales totals for the month against each name.
Then i do a Conditional Format for the Top5. (There are no duplicates).
Can i plot a chart ONLY for the Top5 directly based on CF ?
Thank you.

 

[Khalid NGO]

Hi James,
You can use helper table to get Top5, then apply chart on it.

 

[Hui]

See attached
It is all done using named formula

 

[James Perry]

Excellent! Exemplary!
God bless! God bless! God bless!
Thanks, Hui.