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.

With Excel's versatile chart tool, putting together data visualizations is as easy as pie (groan).

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.