polewblogging.blogg.se - How to make a pie chart in excel 2007

Select the 6 cells we’ve just created, then go to Insert, then select Pie, and select 2D.

Make sure your values match the ones shown on the right.

Repeat this process for East and West, until you have something like this.

Enter this value in a cell somewhere to the right of the table, and create an adjacent cell reading Central. According to the “Count” at the bottom right, there are 24 of these.

With the data sorted, select all of the cells in the Region column that read Central.This is because we selected A-Z for the order. Your data should now be sorted by region, and should first show Central, then East, then West.On the drop-down menu next to “Sort By,” select “Region.” This will sort your data so that all of the values are grouped by their Region value (East, West, or Central).Click the “Data” tab near the top of the page, then “Sort”.Highlight the entire set of data, from the uppermost left cell to the lowest right cell.Ignore or delete the links on the second spreadsheet – we will not be using them. Download the data and open it in Microsoft Excel.First off, you’ll need the data for it.I am using the 2007 version of Excel, so your tabs and such may look slightly different. Disclaimer: this tutorial is not meant for Open Office or any other program that isn’t Excel, so the instructions may be confusing or impossible if you aren’t using Excel.