How to Create a Date & Cost Line Chart in Excel. ... Move the dates and costs to adjacent columns in your worksheet, if they aren't already there. Click the uppermost cell in the date column.