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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |