Excel Charts - Creating Charts
In this chapter, we will learn to create charts.
Creating Charts with Insert Chart
To create charts using the Insert Chart tab, follow the steps given below.
Step 1 − Select the data.
Step 2 − Click the Insert tab on the Ribbon.
Step 3 − Click the Insert Column Chart on the Ribbon.
The 2-D column, 3-D Column chart options are displayed. Further, More Column Charts… option is also displayed.
Step 4 − Move through the Column Chart options to see the previews.
Step 5 − Click Clustered Column. The chart will be displayed in your worksheet.
Step 6 − Give a meaningful title to the chart by editing Chart Title.
Creating Charts with Recommended Charts
You can use the Recommended Charts option if −
You want to create a chart quickly.
You are not sure of the chart type that suits your data.
If the chart type you selected is not working with your data.
To use the option Recommended Charts, follow the steps given below −
Step 1 − Select the data.
Step 2 − Click the Insert tab on the Ribbon.
Step 3 − Click Recommended Charts.
A window displaying the charts that suit your data will be displayed, under the tab Recommended Charts.
Step 4 − Browse through the Recommended Charts.
Step 5 − Click on a chart type to see the preview on the right side.
Step 6 − Select the chart type you like. Click OK. The chart will be displayed in your worksheet.
If you do not see a chart you like, click the All Charts tab to see all the available chart types and pick a chart.
Step 7 − Give a meaningful title to the chart by editing Chart Title.
Creating Charts with Quick Analysis
Follow the steps given to create a chart with Quick Analysis.
Step 1 − Select the data.
A Quick Analysis button 
appears at the bottom right of your selected data.
Step 2 − Click the Quick Analysis icon.
The Quick Analysis toolbar appears with the options FORMATTING, CHARTS, TOTALS, TABLES, SPARKLINES.
Step 3 − Click the CHARTS option.
Recommended Charts for your data will be displayed.
Step 4 − Point the mouse over the Recommended Charts. Previews of the available charts will be shown.
Step 5 − Click More.
More Recommended Charts will be displayed.
Step 6 − Select the type of chart you like, click OK. The chart will be displayed in your worksheet.
Step 7 − Give a meaningful title to the chart by editing Chart Title.
