I will to plot a line graph of year vs. sales on excel 2010. However, the years are displaying on the y-axis wihile nothing but 1,2,3 etc is displaying on the x-axis.... Anybody might know what the problem is?
Put years (x values) into a column, and the y values into the next column. Put a label in the cell just above the top Y value, and keep the cell just above the top X value blank. Select this range and make an XY chart.