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.

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.