Type in the X axis data in the leftmost column of your worksheet. For instance, type in months 1 through 12 in column "A." Type in the Y axis value for the first data set in an adjacent column.