Follow the steps below to change the Chart Type in Excel: Select the Chart, then click the Change Chart Type button in the Type group on the Chart Design tab. A Change Chart Type dialog box will open.

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.