For example, you could show line graphs for temperature and humidity on top of each other. For this purpose, Excel lets you add a series of data to a chart and plot it on a second y-axis.

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.

How to Add a Secondary Axis to an Excel Chart Excel charts offer a variety of ways to visualize data. When using an X-and-Y-axis layout, you can display a data series that enables you to compare ...