Select the data across both the columns (from A3 to B12). Go to Insert > Line Chart. Select the appropriate line chart. Change the location and size of the chart as per your needs.

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 ...

Go to the Insert tab and insert a 2-D line graph. Right-click on the line and select the Format Data Series. Go to the Fill & Line tab. Check the Smoothed line option.

Click the "Insert" tab at the top of the screen. Click one of the graph options in the "Charts" section, such as "Line." Choose one of the options from the drop-down menu, such as "Line with Markers." ...

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.

How to create the combo chart Right now, the line chart doesn’t display the Emphasis series — the value $1,800,000 — as a vertical bar. It’s a round marker.

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.

Displaying values on a map chart is more meaningful than handing someone a sheet of data. Thanks to Microsoft Excel's Geography data type, creating a map chart is easier than you might think.