Section 2.3. Pivot Table Options


2.3. Pivot Table Options

In this chapter I have tried to show how pivot tables and charts can be used to analyze business problems, but there are many more features and options. In Step 3 of the PivotTable Wizard there is an Options button. You can launch the wizard by right-clicking anywhere in the pivot table area. The Options button brings up the dialog shown in Figure 2-31.

This gives you control over the general formatting and layout of the table, and the Data source options (bottom left) can be helpful if pivot tables are the end product for your users and you don't want them to have the original data.

Figure 2-31. The options dialog




Analyzing Business Data with Excel
Analyzing Business Data with Excel
ISBN: 0596100736
EAN: 2147483647
Year: 2006
Pages: 101
Authors: Gerald Knight

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net