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.

Add an Excel chart to a comment There may be times when you want to display a Microsoft Excel chart with your data, but you don't want it to take up the space on the worksheet. One solution is to ...

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.

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.

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