How to creating chart

Creating Charts 

 You can create a chart on its own sheet or as an embedded object on a worksheet. 
To create a chart, you must first enter the data for the chart on the worksheet, then select the cells and use the Chart Wizard

Try This  

 1. Select the type of chart you wish to create using the Chart Wizard. You can preview how the chart will look by moving the mouse pointer to the Press and Hold to View Sample button.   

2. Click Next and continue with the wizard. You will see the Data Range tab displayed on step 2 of 4. Excel should automatically detect how your series is laid out, however, you can change this if it determines incorrectly by clicking the radio button for the Series in: option yourself. 

3. If you click on the Series tab, you’ll be given the opportunity to change some of the labels used, or pull them from another place on the spreadsheet. 

 4. By clicking Next, you move on Step 3 where you may make other changes to your chart through the use of various tabs. 

5. Clicking Next again will give you the final step, the option to choose where the chart is placed:
• As New Sheet: (Give the Sheet a Name)
• As Object In: Select Sheet

This is an example of a chart that was created as an object in the open sheet following the steps above.