Add a new Pivottable or Pivotchart and reuse the slicers of an existing PowerPivot workbook

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

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:

Read more...

 

Tags: tip, excel

 

2007-2015 VidasSoft Systems Inc.