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 − Cpck the Insert tab on the Ribbon.

Step 3 − Cpck 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 − Cpck 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 − Cpck the Insert tab on the Ribbon.

Step 3 − Cpck 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 − Cpck on a chart type to see the preview on the right side.

Step 6 − Select the chart type you pke. Cpck OK. The chart will be displayed in your worksheet.

If you do not see a chart you pke, cpck 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 − Cpck the Quick Analysis icon.

The Quick Analysis toolbar appears with the options FORMATTING, CHARTS, TOTALS, TABLES, SPARKLINES.

Step 3 − Cpck 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 − Cpck More.

More Recommended Charts will be displayed.

Step 6 − Select the type of chart you pke, cpck OK. The chart will be displayed in your worksheet.

Step 7 − Give a meaningful title to the chart by editing Chart Title.