To create a chart in excel select the cells that contain the data you want to make a chart out of.
Click on the charts tab.
Decide what kind of chart you’d like to display and click on it.
Select the option you’d like from the drop down.
A chart will now be created for that data set.