Enable Chart Tool options by clicking anywhere within an Excel 2007 or 2010 chart whose information you want to modify. Click Design on the main menu, then Layout and finally, select Axis Title or ...

Excel automatically distributes these points along a uniform X axis. To add more data to the Y axis in a line chart, add additional numbers in cells below your existing data.