How to Have Three Secondary Axes on Excel 2007. Excel 2007's secondary axis feature enables you to view two different data series with two distinct scales, all on the same chart. Use this feature ...

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.