|
Topic 31: Step-by-Step Guide to Creating a Pie Chart
Create a worksheet as follow as we will use it to demonstrate the steps to create a pie chart in Excel 2007:
http://www.msoffice-tutorial-trainin...-worksheet.gif We can see that WindSports Sales are broken apart into categories. Vertically, in Column A, we can see that WindSport has categorized the sales according to the products that they sell: boomerangs, kites and toys. Horizontally, in Row 2, we can see that WindSport has categorized the sales according to the sales channels that they use for selling: In Store, Web Site and Mail Order. In addition, they have listed totals for each category and an overall total in the lower-right corner. For our first Chart we would like to show how each product total contributes to the overall total. This means that we are comparing three "parts" (boomerangs, kites, toys) to the overall total to see what proportion or percentage that each contributes to the whole. Anytime you have this situation (comparing parts to the overall total), a Pie chart type is an excellent choice. |
To create and customize a pie chart
1. Highlight the range A3:A5, then hold the Ctrl key, and select the second range E3:E5 (you are selecting two ranges of cells that are not adjacent to each other). 2. From the Insert Tab, in the Charts group, point to the Pie chart icon. |
3. Click on the Pie chart icon and then point to the first option. As you can see, Excel gives you a description of what the chart should be used for. As you learn how to make charts, you can read these as you are trying to decide which chart is best for your message.
|
4. Click on this first option to create your Pie chart. You can see that it placed a pie chart on top of the worksheet and opened the three contextual tabs for charts.
|
5. To change the size of the chart, hold the Shift key and point to the upper left corner of the chart and when you see a diagonally pointing black arrow, click and drag inward. You should change the size to about the same size as seen in figure below:
|
| All times are GMT. The time now is 05:45 PM. |
Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2024, vBulletin Solutions, Inc.