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.

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.

Charts are great for showing comparisons and trends. In this tutorial, we will explain how to apply layouts and styles in a chart in Excel.

First, you must display the second axis by selecting the orange vertical bar and then doing the following: In the Chart Layouts group, click Add Chart Element. From the dropdown, choose Axes.