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. I am using the 2007 version of Excel, so your tabs and such may look slightly different.
Getting and organizing the data
- First off, you’ll need the data for it.
- Download the data and open it in Microsoft Excel. It should be automatically formatted. Ignore or delete the links on the second spreadsheet – we will not be using them.
- Highlight the entire set of data, from the uppermost left cell to the lowest right cell.
- Click the “Data” tab near the top of the page, then “Sort”
- 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)
- Your data should now be sorted by region, and should first show Central, then East, then West. This is because we selected A-Z for the order.
Creating a Pie Chart
- With the data sorted, select all of the cells in the Region column that read Central. According to the “Count” at the bottom right, there are 24 of these. Enter this value in a cell somewhere to the right of the table, and create an adjacent cell reading Central.
- Repeat this process for East and West, until you have something like this. Make sure your values match the ones shown on the right.
- Select the 6 cells we’ve just created, then go to Insert, then select Pie, and select 2D
- You should now have something like this
- Now we’re going to add percentage values to the chart. To do this, simply select the pie chart we’ve created, then go to the top of the page and select Design, then choose a Chart Layout with a percentage value included. For the sake of this example, I am selecting Layout 6.
- Your pie chart should now look like this. We’re almost done!
- We’re going to make a few small changes to this graphic to make it look better, but at this point all you really need to do is add a title by double-clicking the “Chart Title.” Let’s rename it to “Distribution of Orders by Region.”
- Once you’ve done this, click once on any of the three % boxes on the pie chart. Make sure that your graph currently looks like this. If you’ve accidentally selected something else, or the entire chart, click one of the empty cells elsewhere and try again.
- With those boxes still selected, go to the “Home” tab at the top, and select the font size. Increase it to 20. Then select the Central, East, West key on the right of the pie chart and do the same thing to it. Reminder, all you have to do is click the box once, then change the font settings in the Home tab.
- That’s it! We’re done! If you’d like to change the font type, color, etc, just make sure you’ve selected these boxes when you make changes. If you’d like to change the pie chart style, you can always go back to the Design tab and play around with Layout, colors, etc.
This is what the final product looks like.
If you want to change the data in a graph in Microsoft Excel, you can do so by changing the cells the graph is drawing from. In this case, changing the 24 (Central) to a 50 would change the graph instantly to reflect a much larger portion of the Orders to be from Central.