Copyright © 2011 by Pearson Education Inc. publishing as Prentice Hall. All rights reserved.From Skills for Success with Microsoft® Excel 2010 Comprehensive

Import Data, Create PivotTable Reports and PivotChart Reports | Microsoft Excel Chapter 9 More Skills: Skill 13 | Page 1 of 4

� The type of chart in a PivotChart can be changed to better display the underlying data.

To complete this document, you will need the following file:� e09_Catering_Sales

You will save your workbook as:� Lastname_Firstname_e09_Catering_Sales

1. Start Excel, and open the student data file e09_Catering_Sales. Save the file in yourExcel Chapter 9 folder with the name Lastname_Firstname_e09_Catering_Sales

2. Display the PivotChart worksheet. In the PivotTable Field List, under Choose fields to add to report, select the Vendor check box and the Amount check box. Move the upper left corner of the PivotChart report into cell A9.

3. Display the Design tab, and then in the Type group, click Change Chart Type.Compare your screen with Figure 1.

The Change Chart Type dialog box lists the types of charts that can be assigned to a PivotChart.

ExcelCHAPTER 9

More Skills 13 Change PivotChart Report Types and Print PivotChart Reports

Figure 1

Change ChartType button

Change Chart Typedialog box

Column chartselected

Copyright © 2011 by Pearson Education Inc. publishing as Prentice Hall. All rights reserved.From Skills for Success with Microsoft® Excel 2010 Comprehensive

Import Data, Create PivotTable Reports and PivotChart Reports | Microsoft Excel Chapter 9 More Skills: Skill 13 | Page 2 of 4

4. In the Change Chart Type dialog box, in the left pane, click Bar.

5. In the Chart Type gallery, under Bar, click the first chart—Clustered Bar.Compare your screen with Figure 2, and then click OK.

Figure 2

Clustered Barchart selected

6. On the Design tab, in the Chart Styles group, click the More button . In the Chart Stylesgallery, click Style 42. In the Chart Layouts group, click the More button , and then in theChart Layout gallery, click Layout 7.

7. On the Layout tab, in the Labels group, click Chart Title, and then click More TitleOptions. In the Format Chart Title dialog box, under Fill, click the Solid fill option button.

8. In the Format Chart Title dialog box, click the Color button arrow. Under Theme Colors,click the tenth color in the fifth row—Orange, Accent 6, Darker 25%. Click Close.

9. Right-click the Chart Title, and then from the displayed shortcut menu, click Edit Text.Replace the contents of the box with Vendors Select cell A1, and then compare your screenwith Figure 3.

Copyright © 2011 by Pearson Education Inc. publishing as Prentice Hall. All rights reserved.From Skills for Success with Microsoft® Excel 2010 Comprehensive

Import Data, Create PivotTable Reports and PivotChart Reports | Microsoft Excel Chapter 9 More Skills: Skill 13 | Page 3 of 4

Figure 3

Chart Titleinserted and

formatted

10. Select both worksheets, and then add the file name in the left footer. Return to Normalview, and select cell A1.Ungroup the worksheets. Save the workbook.

11. Display the PivotChart worksheet, and then select the PivotChart. Display the File tab, andclick Print. In the Settings group, verify that Print Selected Chart is displayed. Compareyour screen with Figure 4.

Copyright © 2011 by Pearson Education Inc. publishing as Prentice Hall. All rights reserved.From Skills for Success with Microsoft® Excel 2010 Comprehensive

Import Data, Create PivotTable Reports and PivotChart Reports | Microsoft Excel Chapter 9 More Skills: SKILL 13 | Page 4 of 4

Figure 4

Print Preview

Print SelectedChart

12. Verify that the PivotChart Report fits on a single page. If you are printing your work for thischapter, click Print.

13. Click Exit. Submit the workbook as directed by your instructor.

� You have completed More Skills 13