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 1</SPAN>
Date</SPAN>	EMP #</SPAN>	Employee</SPAN>	Designation</SPAN>	Production (Dzn)</SPAN>
1-Jan-18</SPAN>	223873</SPAN>	Saim Sonu</SPAN>	Helper</SPAN>	1250</SPAN>
2-Jan-18</SPAN>	223873</SPAN>	Saim Sonu</SPAN>	Helper</SPAN>	1140</SPAN>
3-Jan-18</SPAN>	223873</SPAN>	Saim Sonu</SPAN>	Helper</SPAN>	1560</SPAN>
4-Jan-18</SPAN>	223873</SPAN>	Saim Sonu</SPAN>	Helper</SPAN>	1100</SPAN>
5-Jan-18</SPAN>
6-Jan-18</SPAN>
7-Jan-18</SPAN>
Table 2</SPAN>
Date</SPAN>	EMP #</SPAN>	Employee</SPAN>	Designation</SPAN>	Production (Dzn)</SPAN>
1-Jan-18</SPAN>	224504</SPAN>	M.A Aslam</SPAN>	Helper</SPAN>	1133</SPAN>
2-Jan-18</SPAN>	224504</SPAN>	M.A Aslam</SPAN>	Helper</SPAN>	1185</SPAN>
3-Jan-18</SPAN>	224504</SPAN>	M.A Aslam</SPAN>	Helper</SPAN>	1229</SPAN>
4-Jan-18</SPAN>	224504</SPAN>	M.A Aslam</SPAN>	Helper</SPAN>	950</SPAN>
5-Jan-18</SPAN>
6-Jan-18</SPAN>
7-Jan-18</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL></COLGROUP>

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