Put your answers on challenge tab example 2 pivot

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Pivot Charts Pivot charts operate in a similar manner to pivot tables, but the data is displayed in chart form. To insert a pivot chart, go to the 'Insert' ribbon then click on the down arrow below 'Pivot Table'. Construct the following pivot charts for the California NOx dataset. Display your results on this sheet, below the questions. Note: You can format a pivot chart in the same manner you would a normal chart. 1) A stacked column chart displaying total NOx emissions for each facility SIC number, for the years 2000 to 2005. Each SIC code should be represented by a different color of the stacked column. Legend Fields: Facility SIC Code Axis Fields: Year Value Fields: Sum of NOx (tons) What 3 SIC codes appear to contribute most on NOx pollution? 2) A line chart of each Air Basin's total NOx emissions from 2000 to 2005. Have the years denoted on the horizontal axis. Using the pivot table filters, display only the top 5 Air Basins in terms on total NOx. Based on the graph, which of the top 5 Air Basins saw the biggest decline in total Nox emissions from 2000 to 2005? Example 3 - Other Summary and Display Options 1) Using the California Nox data, create a pivot table that reports the average NOx emissions of the facilities in each Air Basin (each cell of the pivot table will be the average NOx emissions of all the facilities in that air basin across all years). Which Air Basin has the most emissions intensive facilities (highest average emissions)? 2) Using the California Nox data, create a pivot table that for the year 2000, reports the percentage of each Air Basin's total NOx that comes from facilities with each SIC code. Other Stuff 1) What does double clicking on an entry within a pivot table do? 2) How do you remove the grand totals rows/columns from a pivot table?...
View Full Document

This note was uploaded on 02/07/2013 for the course AEM 2010 taught by Professor Klotz during the Fall '12 term at Cornell.

Ask a homework question - tutors are online