Naming Basics Best practice recommendations are to create a chart placing independent variables on the horizontal, x-axis and dependent variables on the vertical, y-axis.

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.

If you have uneven distribution of data in your Excel chart, here is a better way to change the automatic axis settings.

ADJUST THE AXIS SCALE ON AN EXCEL CHART Excel usually does a good job second-guessing me when it chooses the scale for an axis on a chart. But sometimes, to better focus some data, I need to adjust ...

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.