Creating Excel Pie Chart

How to Create an Excel Pie Chart?

Here is the step-by-step guide to create an outstanding Excel pie chart:

Key in the data illustrated below accordingly as we will use it as our example to create chart.

Step 1: The Chart Wizard (1) – Chart Type

Click on any cell within the data containing the information that you wish to display as a chart, or highlight the exact data that you wish to display as a chart.

Click the Chart Wizard icon on the Standard toolbar.

pie chart types

From the Chart type: section you can select the chart type: Pie.

Then from the Chart sub-type: section you can select the exact format that you required for the selected chart type.

To see how the selected chart will look, use the Press and Hold to View Sample button within the dialog box. In our example, we accept the default selection.

Click the Next button to see the next page of the dialog box - Chart Source Data.

Step 2: The Chart Wizard (2) – Data Source

The Data Range tab allows you to specify the exact data that you wish to display within your chart.

You can choose to display Series in Rows or Columns. In our case here, choose the Series in Columns will be more appropriate.

pie chart data source

When you click on the Next button, this will display the Chart Options dialog box.

Step 3: The Chart Wizard (3) – Chart Options

From the chart options dialog box displayed, you can select Titles, Legend, and Data Labels tabs and make the necessary changes.

To add title to a chart

In the Chart title: text box, enter the name for the chart, i.e. Score Marks.

In the example used, the screen will be as illustrated.

To customize chart legend

From the Chart Option dialog box displayed, click on the Legend tab.

You can choose to display or not the chart legend and the placement of the legend in the chart by clicking on the radio button.

To customize data labels

From the Chart Option dialog box displayed, click on the Data Labels tab.

You can choose to display or not the chart data labels by clicking on the radio button. In our example, tick the Percentage check box to display the percentage info.

pie chart data labels

When you click on the Next button, this will display the Chart Location dialog box.

Step 4: The Chart Wizard (4) – Chart Location

To define the chart location

You can choose to place the Excel pie chart on an existing worksheet as an object, or you can place it on a new worksheet. Two options for you to choose:

As new sheet: – It will place the chart in the new worksheet.
As object in: - It will place the chart in the existing worksheet.

pie chart location

Click on the Finish button and the Excel pie chart will be created as you have specified during the Chart Wizard creation process.

Can't find what you're looking for? Try Google Search!

Back to Top

Recommended book:

Revealed! 101 Excel Secrets

>> Next Topic : Using the Excel Paste Special Feature Effectively

<< Previous Topic : How to Use the Excel DATE( ) Function Correctly?

You're viewing the Excel Pie chart info page, click here to go back to the Home Page