Plotting 3 data series with different dates on 1 chart!

[ADAMSKI89]

Hi Guys,


[TABLE="width: 700"]
<tbody>[TR]
[TD]Order #[/TD]
[TD]Part Count[/TD]
[TD]Estimated EOL[/TD]
[TD]Station 1[/TD]
[TD]Station 6[/TD]
[TD]End of Line[/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]3[/TD]
[TD]17/6/18[/TD]
[TD]12/6/18[/TD]
[TD]14/6/18[/TD]
[TD]18/6/18[/TD]
[/TR]
[TR]
[TD]234567[/TD]
[TD]5[/TD]
[TD]19/6/18[/TD]
[TD]14/6/18[/TD]
[TD]15/6/18[/TD]
[TD]ongoing(left blank in my data)[/TD]
[/TR]
</tbody>[/TABLE]

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!