Share this Page URL

Chapter 11. Analyzing Data with PivotTab... > Using a PivotChart to Display and An... - Pg. 401

Analyzing Data with PivotTables and PivotCharts 401 6. With the Properties dialog box open, you can use the By Row/By Column button to switch the orientation of the chart and then review how different chart types represent the data. In the Properties dialog box, select the Clustered Column chart variety (the first item in the top row of the Column chart types) so that the PivotChart uses the type we began with, and then close the Properties dialog box. As you might have noticed, when you create a PivotChart, the horizontal and vertical axis are labeled Axis Title. To make a chart ready for presentation, you should change these labels so that they reflect the data the chart displays. You can add other formatting to a PivotChart as well--you can change its background color, the font used in the legend, and the colors used to represent the chart's series values in columns or bars. In the following steps, we'll apply formatting to the Expenses PivotChart and describe some Piv- otChart properties as well. Format and set properties for a PivotChart 1. Right-click the label Axis Title at the left side of the chart, and then click Properties. On the General tab of the Properties dialog box, shown here, the Select list includes a catalog of all the elements in the PivotChart. When you are formatting chart elements, you can select the element you need from this list or click the element in the chart itself.