![]() We can give our pie chart a little more depth by adding a shadow to each pie slice. The percentages are added to each pie that correspond to the percentage of total votes. With the chart selected, click Chart Tools > Design > Chart Layouts > Layout 1 (the first one). We can see at a glance how big the share of votes each party received as a proprtion of the whole, but we can also add some percentages for the number crunchers to look at. There are some useful additions that we can make to this pie chart. Adding Percentages To Pie Charts In Excel I’m not suggesting that you engage in vote rigging, but if you change the number of votes that the Green party received to 5,000, you will see their portion of the pie chart expand to reflect your change. The beauty of charts in Excel 2010 is that they change immediately to reflect the data in your spreadsheet if you choose to amend any of the figures. Notice that because we selected the headings as well as the data, “Votes” was used as the pie chart’s title, which is just fine. Each party has its own colour, making it easy to identify it in the pie. You can see the relative size of each piece of data quite clearly. I selected one of the 3-D pie charts and created this: Select the data, including the headings, and click Insert > Charts > Pie, and select a chart type. Don’t worry if you don’t know what this means as it’s just the numbers we’ll be looking at. ![]() ![]() We’ll use this data to create a pie chart. Here is a breakdown of the votes for each party in a particular consituency in the UK. Each piece of data is represented as a portion of a whole, so relative sizes are easy to compare. ![]() Unlike other charts in Microsoft Excel, pie charts require that data in your worksheet be contained in only one row or column (although an additional row or column can be used to indicate a “category”). ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |