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.

A line chart connects a series of data points and is used by traders to monitor prices, currencies, indexes, and other data.