INSY 2299 Lecture Notes - Lecture 3: Pie Chart
22 Jun 2018
School
Course
Professor
Excel: PivotTables and Charts
PivotTables (Excel)
Pivot tables are Excel’s version of multidimensional data cubes
Multidimensional data cubes are a visual method of considering and interpreting data
Since people understand data better in two dimensions, the goal is to reduce the
dimensions down to two
oMethod: “Slice the cube” (look at one piece of the cube at a time)
oMethod: Disregard some dimension(s) and sum up the values into one two-
dimensional table
Creating PivotTables
1. Highlight the entire table in Excel.
2. Select PivotTable (under the Insert tab).
3. Confirm the table/range and the location of the PivotTable.
4. Use the PivotTable fields list to add dimensions and values.
**PivotCharts can be used to further illustrate PivotTables**
Why do we use charts in Excel?
Goal: Convey information visually to help users gain a better understanding of data
Well-designed and well-labeled charts make data easier to read and analyze
Pie Charts
The slices of a pie chart must add up to a whole, and cannot be negative
When choosing the elements to be included, make sure that there is a meaningful
relationship between them
Labels are not always necessary; sometimes a legend will suffice
Bar Charts
The Select Data Source box can be used to edit the various elements of a bar chart
Bar charts can be used to show data over time
oLine charts can be used to show trends over time
find more resources at oneclass.com
find more resources at oneclass.com
Document Summary
Pivot tables are excel"s version of multidimensional data cubes. Multidimensional data cubes are a visual method of considering and interpreting data. Creating pivottables: highlight the entire table in excel, select pivottable (under the insert tab), confirm the table/range and the location of the pivottable, use the pivottable fields list to add dimensions and values. **pivotcharts can be used to further illustrate pivottables** Goal: convey information visually to help users gain a better understanding of data. Well-designed and well-labeled charts make data easier to read and analyze. The slices of a pie chart must add up to a whole, and cannot be negative. When choosing the elements to be included, make sure that there is a meaningful relationship between them. Labels are not always necessary; sometimes a legend will suffice. The select data source box can be used to edit the various elements of a bar chart.
