If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

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 Excel Charts Work A chart has an x-axis range and a y-axis range to show the correlation between two different data sets. The x-axis is the horizontal category line.

A linear equation is drawn as a straight line on a set of axes. To draw the graph we need coordinates. We generate these coordinates by substituting values into the linear equation.

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.