|
5.
What Else Do You See? When you edit the PivotChart, you are
modifying the PivotTable as well. The
Column Labels show new subtotals for each product. The subtotals
calculate how much product each sales rep sold. The
PivotTable was formatted automatically with banded columns.
Rename
this spreadsheet PivotTable by Category and Save your work.
Memo to Self: As you work with
the tools you should keep in mind the purpose of this chart. What story
are you trying to convey in a quick, effective visualization? Would
it be easier to see the data as a PivotTable?
Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.4. Apply and manipulate PivotCharts
PivotChart Tools ->Analyze
|
|
| |
