• 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.

Help in Dash board creation for different KPIs

Dheeraj0501

New Member
Please find the attached data sheet from which a dash board has to be created for following KPIs
1. Trips per day per driver in between two selected dates
2.Trips per day per truck in between two selected dates
3.Tons per truck per day in between two selected dates
4. revenue per truck - company wise
5.revenue per truck per day between two dates
6. Space for comments to be displayed for low productivity when particular date is selected
 

Attachments

  • Masterdata151219 - Copy.xlsx
    299.9 KB · Views: 37
Hi Asheesh

I used the Pivot table and chart and it solved the problem mostly....thanks though, for the links....I need to practice more make those awesome looking charts...
 
Great, To solve a problem yourself helps you learn more..and trust me, the more you explore excel and practice the more you learn ..
 
Back
Top