Microsoft Office Tutorials and References
In Depth Information
When you create a pivot chart using the Data Model, you can convert the pivot table to
formulas. Select any cell in the pivot table and choose PivotTable Tools Ana-
lyze OLAP Tools Convert to Formulas. The pivot table is replaced by cells that use
formulas. These formulas use CUBEMEMBER and CUBEVALUE functions. Although the
range is no longer a pivot table, the formulas update when the data changes.
Figure 18-51: The pivot table, after adding two slicers.
Creating Pivot Charts
Search JabSto ::

Custom Search