Dynamic dashboard using drop down.

[Renison patelia]

Hi everyone, I need to have dynamic chart using drop down list. I have tried index and match, vlook up, hlook up but couldn't successed.

The excel sheet is attached here with for your kind idea and support.

Requirement is to have the disciple wise chart (I. E. Mech, elec, inst) in sheet name chart. The data is available in sheet name data.

Thanks in advance.

Regards

RP

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[Renison patelia]

Dear Narayan thanks for the feedback. There is nothing in the file u have shared.. It's just as it is as I have shared... What you are trying to share bro..

Regards,

 

[Renison patelia]

Dear experts, yet to get the answer on my query.

Hi everyone, I need to have dynamic chart using drop down list. I have tried index and match, vlook up, hlook up but couldn't successed.

The excel sheet is attached here with for your kind idea and support.

Requirement is to have the disciple wise chart with drop down list(I. E. Mech, elec, inst) in sheet name chart. The data is available in sheet name data.

Thanks in advance.

Regards

RP

 

[NARAYANK991]

Hi ,

Did you change the dropdown selection ?

Narayan

 

[Renison patelia]

Dear I am able to get the details now but I would appreciate if you can share how you did it.. renison_p86@yahoo.com

 

[Chihiro]

Check Name Manager.

Drop down selection is given "SelectedDispline" as name. Then that is used to evaluate "SelectedPlan" and the in turn, it's used to get SelectedActual.