Date Box For Date Selection and Data of Table 2 required in Chart

[Navi_G]

Hi,

i am working on active x control and chart but i need true guide lines.
i) In spread sheet i need to a Date list Box (Active x control) for date selection like 12-Mar-2018.
ii) In Second thing i need to select in chart (Bar Chart) From Table 1 and Table 2.

Illustrations:
[TABLE="width: 524"]
<TBODY>[TR]
[TD]Table 1</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date</SPAN>[/TD]
[TD]EMP #</SPAN>[/TD]
[TD]Employee</SPAN>[/TD]
[TD]Designation</SPAN>[/TD]
[TD]Production (Dzn)</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1-Jan-18</SPAN>[/TD]
[TD="align: right"]223873</SPAN>[/TD]
[TD]Saim Sonu</SPAN>[/TD]
[TD]Helper</SPAN>[/TD]
[TD="align: right"]1250</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]2-Jan-18</SPAN>[/TD]
[TD="align: right"]223873</SPAN>[/TD]
[TD]Saim Sonu</SPAN>[/TD]
[TD]Helper</SPAN>[/TD]
[TD="align: right"]1140</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]3-Jan-18</SPAN>[/TD]
[TD="align: right"]223873</SPAN>[/TD]
[TD]Saim Sonu</SPAN>[/TD]
[TD]Helper</SPAN>[/TD]
[TD="align: right"]1560</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]4-Jan-18</SPAN>[/TD]
[TD="align: right"]223873</SPAN>[/TD]
[TD]Saim Sonu</SPAN>[/TD]
[TD]Helper</SPAN>[/TD]
[TD="align: right"]1100</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]5-Jan-18</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]6-Jan-18</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]7-Jan-18</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Table 2</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date</SPAN>[/TD]
[TD]EMP #</SPAN>[/TD]
[TD]Employee</SPAN>[/TD]
[TD]Designation</SPAN>[/TD]
[TD]Production (Dzn)</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1-Jan-18</SPAN>[/TD]
[TD="align: right"]224504</SPAN>[/TD]
[TD]M.A Aslam</SPAN>[/TD]
[TD]Helper</SPAN>[/TD]
[TD="align: right"]1133</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]2-Jan-18</SPAN>[/TD]
[TD="align: right"]224504</SPAN>[/TD]
[TD]M.A Aslam</SPAN>[/TD]
[TD]Helper</SPAN>[/TD]
[TD="align: right"]1185</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]3-Jan-18</SPAN>[/TD]
[TD="align: right"]224504</SPAN>[/TD]
[TD]M.A Aslam</SPAN>[/TD]
[TD]Helper</SPAN>[/TD]
[TD="align: right"]1229</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]4-Jan-18</SPAN>[/TD]
[TD="align: right"]224504</SPAN>[/TD]
[TD]M.A Aslam</SPAN>[/TD]
[TD]Helper</SPAN>[/TD]
[TD="align: right"]950</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]5-Jan-18</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]6-Jan-18</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]7-Jan-18</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</TBODY><COLGROUP><COL span=2><COL><COL><COL></COLGROUP>[/TABLE]

Chart is not attached sorry. But is based only Table 1 and i not know how attach table 2 data with chart please guide me.

Thanks
Navi_G

 

[Navi_G]

Check out this illustration....

Thanks
Navi_G