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

Want to make a dynamic dashboard

Hi Excel Gurus,

I want to make a dynamic dashboard with the data given in the attached file.

There are two sheets in the attached file.
1) Sample
2) Data

I had made the sample file which shows different type of parameters along with a chart of all the dates with a desirable value.

Request you to kindly help in creating a dashboard wherein with just a filter or a drop down I can show my Boss what is the status of the parameter with a chart and desirable value. The data is in the "Reqd Data"


Thanks
Raj
 

Attachments

  • DATA.xlsx
    41.3 KB · Views: 22
see attached.
Top left of chart sheet, Parameter dropdown allows you to choose what to show.
It requires a rearrangement of your data as in REQD DATA G1:L187
 

Attachments

  • chandoo15273DATA.xlsx
    107.9 KB · Views: 69
Back
Top