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.

A graph or chart makes the spreadsheet productive and attractively visualizes the data. It is straightforward to create and add a graph – whether you are using Microsoft Excel or Google Sheets.

How to make a line graph in Excel 1. Open the Excel spreadsheet with the data you wish to use in your line graph. Make sure all of the data is correct. 2. Click and drag your cursor to highlight ...

Change the maximum value to the same value you entered in the Emphasis column, 1,800,000. As you can see in Figure I, the vertical bar now extends to the top of the chart’s plot area.

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.

A burndown chart is easy to create in Excel, but setting up the data takes a good understanding of what the chart represents. You’ll need three columns, as shown in Figure A.