How to create a Line Chart in Excel To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Line Chart.

Tooltip text, when you highlight this option, reads, "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.

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.

You can make a curved graph in Excel and Google Sheets using this tutorial. Learn how to convert sharp edges into smooth lines in a spreadsheet graph.

Figure B The Excel add-in inserts a chart populated with dummy data. How to connect the Excel data to the chart At this point, you’re ready to connect the chart to real data.

Try this easy-to-implement Microsoft Excel chart to keep you and your team members on track.