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.

In Microsoft Excel, to draw attention to a specific marker in a line chart, drop in a thin line, think of it as a marker.

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.

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.

At this point, we could insert a map (chart) based on the existing data set, but let’s add some custom values instead. Suppose you want a map that shows how many stores are in each county.