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.

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

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

    Google
     

    Back to Top


    >> 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