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.

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.

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.

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.

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.

Microsoft Excel is an advanced spreadsheet program that enables you to keep track of and display data in many ways, including bar graphs. Learn how to make a bar graph in Excel from this article.