Chart and graph Help

Hi,

i am working on Bar chart but i need true guide lines.
i want to select data in chart (Bar Chart) From Table 1 to Table 2.

Illustrations:
Table 1
Date EMP # Employee Designation Production (Dzn)
1-Jan-18 223873 Saim Sonu Helper 1250
2-Jan-18 223873 Saim Sonu Helper 1140
3-Jan-18 223873 Saim Sonu Helper 1560
4-Jan-18 223873 Saim Sonu Helper 1100
5-Jan-18
6-Jan-18
7-Jan-18
Table 2
Date EMP # Employee Designation Production (Dzn)
1-Jan-18 224504 M.A Aslam Helper 1133
2-Jan-18 224504 M.A Aslam Helper 1185
3-Jan-18 224504 M.A Aslam Helper 1229
4-Jan-18 224504 M.A Aslam Helper 950
5-Jan-18
6-Jan-18
7-Jan-18

Chart Data is based only Table 1 and i not know how Shuffle table 2 data with chart please guide me.

Thanks
Navi_G

How can i move to another forum please help regarding this...

Ask a moderator - I've moved it for you.

Have you asked this question on any other forums?

Please help me on multiple chart data....

I find, with bar and column charts (and other "category" charts), that it is easiest to first merge the two tables into 1 table. Then the chart is easier to create.

I am not familiar with Get and Transform (https://support.office.com/en-us/art...6-59e18d75b4de ), but that might be the easiest way to combine these two tables into one.

With what I know, I would probably:
1) Select Table 2 -- copy -- paste in the columns next to Table 1.
2) Select the leftmost date column and each production column -> insert chart -> desired bar chart and subtype
3) Fix any of Excel's mistakes in the chart's source data (Select Data dialog).
4) Other formatting as desired.

Thanks For Help Mrshorty