How to take out "Rank" in Chart

[rush2rajen]

Hi Excel Gurus,

Request you to kindly suggest a formula to take out rank so that whenever I select the salesman name the Rank shows on the right hand side.

Excel attached for reference.



Thanks
Raj

 

[vijay.vizzu]

How you would like to rank out. ??
By their actual vs target or by any other...

Please clear...

 

[rush2rajen]

Hi Vijay,

By % of Achievement on Target vs Achvd.

Thanks
Raj

 

[Smallman]

Hi Again Raj

It is a shame you stuck with those colours. Chandoo has some courses on dashboards and how colours go together. These are two which should be kept well apart.

When you are using XL try to avoid putting the criteria for your data validation list in the last column of the spreadsheet. XL recognises that and adjusts the size of the file accordingly.

I have put this additional % on your output tab.

Take care

Smallman

 

[NARAYANK991]

Hi Raj ,

See this file , where the salesman's rank is in the chart.

Narayan

 

[rush2rajen]

Thanks Narayan.

Sorry Smallman for using those colors, will be careful before using it next time.

Thanks
Raj