Performance Report

[jskushawah]

Hi there:

I have made a dashboard attached to:

https://www.dropbox.com/s/7s9c6l7qgiifkwj/t20%20Wold%20Cup.xls


is there another better way to fetch the data in dashboard area ???

Pls suggest the simpler formula.

 

[kaushik03]

Hi jskushawah


To me it looks really good.


But I am sure you will get some advancement ideas from other experts in this forum


Kaushik

 

[NARAYANK991]

Hi ,


There seems to be a problem in 2007 , since Shoaib Malik's name repeats ; the reason for this is that you are using constants such as 25 , 26 , 55 , 56 ,... in your formulae ; always use the ROW(A1) or COLUMN(A1) construct to have the numbers 1 , 2 , 3 ,... Using constants makes copying impossible.


I suggest you try and use the technique shown here :


http://chandoo.org/wp/2008/08/27/excel-kpi-dashboard-sort-2/


where the years 2007 , 2008 and 2009 can be used as column headers , and the rankings for all 3 years are displayed ; clicking on any one column header will sort the data based on the rankings for that year.


Narayan

 

[jskushawah]

Thanks NARAYAN,

I was waiting for such Idea, I will try the technique you suggested.


thanks once again...