Chart Based on Selection Criteria

[premjeetgupta]

Hi Seniors,

I have attached a workbook having 3 sheet "N", "C","D" and "Input Menu". In "Input Menu" sheet there is a drop down called "Type = which is sheet name", "Period=Date", "ID="column "A" of each sheet". I need help to prepare a line chart base on selection criteria. Like if i select Type C; It will show line chart of sheet C.

 

[vletm]

@premjeetgupta
Would You check that file, maybe something is missing or ... ?

 

[premjeetgupta]

Thanks vletm,

Attached was wrong file. Please find correct one.

 

[vletm]

@premjeetgupta
That's much better file ...
There wasn't any Chart ...
but now You have one kind of 'output' with lines.
Do You really know what do You want?

 

[premjeetgupta]

@vletm
Ok, Check i have done some more work to let you understand.

I have added a drop down on "Sheet3" chart but i am unable to select random multiple ID.

So I have also prepared an another chart on "Sheet1" where i have added scroll bar to view multiple ID but again not random.

So now i just need a help how can i view only selected ID data in chart.

 

[vletm]

@premjeetgupta
1) You try to understand.
Check You two files #1 & #3.
How to understand more?
2) How to select random multiple ID?
My known random is something between two values;
Do You know Lotto that's random?
4) How do You select ID?
>> You should try to tell Your vision with clear samples,
not only change ... change.
Make good plan with clear samples of Your vision ...
and upload file.