How to Create a Date & Cost Line Chart in Excel. ... "Line. Insert a line chart. Line charts are used to display trends over time." Excel pastes your chart into a blank part of the worksheet.

If you don’t know how to insert a chart, do the following: Select B2:D8—the data you want in the chart. Include the header text so Excel can generate a legend automatically.

Excel's functionality includes chart options you can insert to add a title directly onto a line graph, so that you don't have to insert extra text boxes or type into the cells around the graph.

Common chart types in Excel. Excel offers a large variety of chart types to choose from. These range from popular general styles such as bar, line, and pie charts to highly specialized styles ...