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.

How to Plot Two Things on the Same Y Axis in Excel. Properly formatted charts and graphs can help you grasp the patterns and trends hidden within the raw data of an Excel spreadsheet.

We discuss a comment on a previous post stating that the text of labels on the vertical axis of graphs must be horizontal by discussing the pros and cons of four possible positions for these labels.