Want to make a dynamic dashboard

[rush2rajen]

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

 

[rush2rajen]

Hi Excel Gurus,

Can you please help on this.

Thanks in advance.
Raj

 

[p45cal]

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

 

[rush2rajen]

Thanks a lot p45cal