Highlight the data that you want to use to create your chart. This first method describes how to create a “pie of pie” chart directly from data entered into a spreadsheet.
Feel free to download this workbook and modify it to use for your own projects. All data and charts created in this series can be found in the file Microsoft Excel 2007 Pie Charts which has been uploaded to the Windows Platform Media Gallery. The example used in this guide is based on data from a monthly budget report that was described in Part 1 of this series. The instructions in the next section will show how to create this type of pie chart. This feature lets you break out these small groups of data into a separate smaller pie chart that is represented as a sub-part of the original whole object. In order to accommodate data of this sort, Microsoft Excel 2007 offers a “pie of pie” option when creating a pie chart. Not only are these cluttered parts on a pie chart hard for the viewer to see, but they can also make the entire graphic look sloppy and unprofessional.
It’s not unusual for a pie chart to be dominated by several large categories within a data set and have a few smaller ones clumped together in a manner that makes them hard to recognize. Pie of Pie Charts in Excel 2007: How to Break Out Small Groups of Data or Small Percentages
0 kommentar(er)
