Select the data in the file for which you want to create a chart.
Click on INSERT > Recommended Charts.
Recommended Charts tab will appear.
From the list of charts click any chart to see how you want your data to look.
In case you do not find a preferred chart, click on All Charts to see all the available charts.
Select the preferred chart, click it > OK.
You can use chart elements, chart styles, buttons, etc, from the upper right corner of the chart and modify it accordingly to add data labels and much more.
Answers & Comments
Verified answer
The steps to create the chart in excel are: