Pivot table / pivot chart

In the Southern region, which are the two most heavily supported interests by corporate donors, and what are the amounts?
Features:  Pivot table / pivot chart.
Instructions: Re-open your original data file: FunWithExcel.  Click on a cell containing data and select Insert, Pivot Chart.
Indicate that your data is in the A1 to F326 range of your existing Excel list, and indicate that you would like to see your results in a new worksheet.  Click OK. Notice that you now have a blank chart in the middle and a blank table on the left.  You should see a list of PivotChart fields in the upper right that are the same as the fields in the upper row of your spreadsheet.
Choose Donor Type, Location, Giving and Interests in the PivotChart Fields list.  The chart should now be really messy and hard to understand.  It- time to clean it  up and make it more useful.  First, click and move Interests from the Axis box on the lower right of the screen to the Legend box.  The chart should become a bit simpler, but still not good.  In the same way, move Location from the Axis box to the Filters box.  Now the chart should be much better.  In the lower left of the chart, you should see a drop down menu labeled Donor Type.  Click on that menu and choose Corporate and Foundation.  In the upper left of the chart you should see a drop down menu labeled Location.  Use that menu to choose South only.  Now you’ll see that you can answer the question, either by looking at the chart or the Pivot Table.

Notice that the Pivot Table in the upper left allows you to make changes using drop down menus.  For example, change the location to west, then change the donor type to volunteer only.  You can see that the graph and/or table adjusts itself to represent the data you have selected.  Use the drop-down menus to return to the original data.
Format the data in the table to Comma Style by highlighting the entire sheet (Ctrl A) and clicking on the comma icon in the formatting toolbar.  Reduce the number of decimal places to 0 by using the decimals formatting icon (.00 to .0).  Now find the data needed to answer the question by using the pull-down menus.  Re-save your file as 301Pivot.
Copy the Pivot Chart and the Pivot Table showing the Southern Region breakdown, including both Corporate and Foundation donor types.