How can I use a slicer in conjunction with a Bell Curve? | Dashboards & Charts | Excel Forum

Hi Fred,

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.

Mynda