Create a chart for MS Excel

Create a chart 

• Click on any cell within the data containing the information that you wish to display as a chart,  or highlight the exact data area that you wish to display as a chart. 
• On the Insert menu,  in the Charts group,  click the chart type you require.  A gallery of thumbnail images for the related chart subtypes will appear. 
• Click the required chart subtype to create the chart,  or click All Chart Types to open the Insert Chart dialog box and choose from all available chart types. 
• When you have selected a subtype,  a chart will be created as an object in the worksheet and Chart Tools will appear on the Ribbon incorporating Design,  Layout, and Format tabs. 
• For example,  when choose the '3-D Clustered Column' subtype, the chart created as follow :
• Alternatively,  click the Charts group Dialog Box Launcher to open the Insert Chart dialog box and see all the available chart types. 
• You can also change the default chart type in the Insert Chart dialog box by selecting a chart type and clicking the Set as Default Chart button. 

Note : To quickly create a chart of the selected data (based on the default chart type)  as an object in the current worksheet,  press Alt+FI. To create a chart of the selected data as a new sheet press F11.