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.

After that, select a 2-D Line graph that you want to display in your spreadsheet. After inserting the graph, right-click on the blue line, and select the Format Data Series option.

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.

Learn how to visualize data in Excel with charts, pivot tables, and tools like Quick Analysis. Transform raw data into actionable insights ...

To do so, right-click the orange vertical bar and choose Format Data Series from the resulting submenu. Be sure to right-click the orange bar and not the line chart.

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.