Charting in Excel is a way to visually represent numbers on a spreadsheet using graphs. Users can draw column charts in Excel, create graphs in Excel... If you learned how to insert charts in Word in the previous article, this one introduces how to create Pie Charts in Excel.
Step-by-step guide on creating Pie Charts in Excel
We have a data table as shown below, ready for inserting a Pie Chart.
For Excel 2003:
Download Office 2003
Step 1: Select the data table, Insert -->Chart.
Step 2: In the dialog box, under the Standard Types tab, choose Pie chart --> select chart style --> press Next.
Step 3: As the dialog box appears, continue pressing Next.
Step 4: In the dialog box, enter the title, then press Next.
Step 5: Press Finish to conclude.
You will create a chart as illustrated below:
2. For Word 2007
Get Office 2007 here
Select the data, including the title, Insert --> Pie --> choose the chart style you wish to create.
Outcome:
You can customize the chart by clicking on it and selecting the Layout tab to alter the chart type.
Outcome:
3. For Excel 2010 and Excel 2013, follow the same steps as Excel 2007
We've just performed the steps to create pie charts in Excel, enabling you to represent figures on your spreadsheet with pie charts. This enhances the visual appeal and understanding of reports and documents.
Drawing diagrams is a relatively simple technique in both Excel and Word. If you're using Word 2010, refer to how to draw diagrams in Word 2010 to learn how to create various diagrams for different needs.