Adding a Second Y-Axis Your new series may not be measured with the same range of numbers as the old one. To make the chart look better, you can plot the new series on a differently scaled 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.