Excel automatically distributes these points along a uniform X axis. To add more data to the Y axis in a line chart, add additional numbers in cells below your existing data.

For even the most new-to-the-program users, compiling a graph in Microsoft Excel is fairly intuitive. Excel offers a one-click option on its "Insert" menu to take data on a spreadsheet and render ...

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.

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.

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.