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.

Excel automatically inserts the graph, but it has no labels. Review the new green "Chart Tools" tab and ribbon at the top of the screen. If you don't see them, click the chart to enable them.

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.

Image: PixieMe/Adobe Stock There are lots of ways to highlight a specific element in a Microsoft Excel chart. You might add data labels or use pictures instead of a plain column in a column chart ...