Need Dynamic Chart

[Shweta]

Hi All,

I need a dynamic chart on my dashboard.

Please find the link below for my file:

http://www.filedropper.com/cycletimeanalysis

Here I explain what I want
On sheet DASHBOARD in cell B30 I have data validation for terminals.
I want when I choose a terminal from this list chart automatically populate the scanning pattern for that terminal on the selected date that is in cell B32 & B34.
Scanning pattern is on the sheet name SCANNING PATTERN.

The range of chart has been selected from the sheet DATA FOR CHART.

Shweta

 

[Shweta]

Can someone please help me out on this?

 

[Steve=True]

Hi Shweta,

Not sure exactly where you need help.

Here is a video and step-by-step tutorial showing you how to do it.
http://www.exceldashboardtemplates.com/?p=688

Hopefully that helps!


Steve=True