Hi,

First time poster here, apologies if this is a common question, I couldn't find an answer with a quick search. If anyone wants to point me towards relevant FAQs that'd be grand, but I'd appreciate being handed this answer on a platter too!

I want to plot a line chart with the date as my horizontal axis and two lines representing two values on any given day (expected stock in, and stock actually arrived.) My data is currently in four columns: Expected stock, Date for this, Stock arrived, Date for this. eg:

40, 24/7/08, 20, 30/7/08

Which indicates I expected 40 stock on 24/8 but only got 20 and on 30/7.

Is there a way of doing this without massively reorganising all my data? I would greatly appreciate any help!