Excel for Decision Making
May 20, 2016
July 16, 2010
You have two options:
1. Insert a dummy PivotTable that contains the field you want in your Slicer. Then insert a Slicer for the PivotTable/field you want.
Build the table that feeds your chart using formulas that reference the PivotTable value (which should be displaying the single organisation selected in the Slicer). e.g. SUMIFS.
2. Create a PivotTable containing all of the data you require for your chart. Insert a Slicer for the organisation. Copy and paste the PivotTable data as values and insert your chart pointing to this data. Set up dynamic named ranges that reference the PivotTable. Edit the chart series to pick up the dynamic named ranges that reference the PivotTable, rather than the static cell ranges that reference your temporary pasted data.
As described in this tutorial: https://www.myonlinetraininghub.com/create-regular-excel-charts-from-pivottables
There are a few ways to approach this. Have a go and if you get stuck please share your file here so we can help further.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas