• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to take out "Rank" in Chart

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
 

Attachments

  • KKKK.xlsx
    16.6 KB · Views: 15
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
 

Attachments

  • ExampleA.xlsx
    18.3 KB · Views: 12
Back
Top