Lesson 4: What Did You See?

(Formatting PivotCharts)

Before You Begin: Download the sample spreadsheet:

Brown Bag Sales Data.xlsx.

 

Try This: Do the following steps

1. Open the spreadsheet: Brown Bag Sales Data.xlsx..

2. Select Sheet 1and Insert a PivotChart on a New Worksheet.

3. Use the PivotChart Tools to Show the Field List

4. Edit the PivotTable Field List as follows:

   Axis Field: Product

   Values: Sum of Amount

5. Use the PivotChart Tool to the Chart Design:

   Change Chart Type: 3D Pie

   Chart Style: Style  6

6. Filter the Row Labels to show Breakfast Sandwiches, Coffee and Tea, and Fruit and Veggie.

7. Use the PivotChart Tools to edit the Chart Layout:

  Legend: None

  Data Labels: Outside End

  3-D Rotation:  edit X to be 50

8. Save this a YOUR NAME What Did You See Practice. 

5. When the rows and columns of a Pivot Table are switched the Chart is switched as well.
a. True
b. False
Tip: Advanced Excel, page 133

6. Which of the following are Chart types that can be applied to a Pivot Chart?

(Select all correct answers.)
a. Column
b. Line
c. Pie
d. Bar
Tip: Advanced Excel, page 135

7. Pivot Charts have Styles
a. True
b. False
Tip: Advanced Excel, page 140

 

8. A chart cannot be moved to a new spreadsheet after it’s been created.
a. True
b. False
Tip: Advanced Excel, page 141