Adding Data Sets One at a Time Launch Excel and load the spreadsheet containing the data you want to plot. Select the first set of X and Y axis data for your chart.

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.