You can create a chart by pre-selecting data, or you can add a chart without data to enter later.
Insert chart
1.Select the data on the worksheet:
•To create a chart using existing data, select the desired range of cells.
•To insert a chart without data, select any empty cell.
2.On the Insert tab, click the Chart button.
3.From the drop-down menu, select one of the chart types.
The chart will be placed in the center of the visible area of the table. The data used for its construction is automatically highlighted on the sheet with colors corresponding to the rows of data in the chart.