| Add a new Pivottable or Pivotchart and reuse the slicers of an existing PowerPivot workbook |
| Written by Kasper de Jonge |
| Friday, 19 March 2010 21:25 |
|
Lets say we have the following pivottable with slicers: now we want to add a PivotChart and have the data from the PivotChart sliced by the slicers we already have in our workbook. Add the chart as usual by clicking PivotTable -> PivotChart and add it to the existing workbook, select the data you want to see in the chart. This will give you the follwoing chart, but not sliced by the available slicers:
|
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
