How to Create a Date & Cost Line Chart in Excel. A date-and-cost line chart tracks a commodity's changing price over time. Economists use such diagrams to display broad market trends and predict ...