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.

The values are plotted across the y-axis and the x-axis is used to mark the progression. In the case of a scatter plot, whether you use it simply with marking points or lines, the graph is spread ...