| 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:
|
Author articles
- AVERAGEX – The 5-point palm, exploding fxn technique revisited
- Project: Gain insight into your music taste using Last.fm, PowerPivot and the PivotViewer
- Predict the future using Predixion data mining and PowerPivot
- Datamining using PowerPivot and Predixion Insight
- Determine the min value over rows in a group using MINX in PowerPivot
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)
- PowerPivot's impact on BI pros?
- Recorded webcast - A Preview to PowerPivot Server Best Practices
