Plotting 3 data series with different dates on 1 chart!

[ADAMSKI89]

Hi Guys,

Order #	Part Count	Estimated EOL	Station 1	Station 6	End of Line
123456	3	17/6/18	12/6/18	14/6/18	18/6/18
234567	5	19/6/18	14/6/18	15/6/18	ongoing(left blank in my data)

<tbody>
</tbody>

Please see the table above - it's essentially a sample of my dataset. I want to achieve an output where I plot estimated part count thru end of line, part count thru station 1, part count thru station 2 & parts complete(End of line) on one graph monthly as 4 separate lines.

To show the data, I'm currently doing the following:

• Creating 4 pivot tables, showing part count by the 4 date columns above.
• Plotting min value station 1 column in A2 & then continue this column using = A2+1 etc. until i'm at the last date
• I then setup 4 columns and insert v-lookups using date into each of the 4 pivot tables setup in step 1.

To me, this seems like alot of work to essentially 'merge' dates. Any help would be greatly appreciated.

Thanks & happy Friday!