I've developed a bell curve to show the distribution of some logging metrics. I want to "Slice" per organization to see where they fall inside the distribution.
Pivot Tables are an option because they don't support x-y scatter charts. Any ideas?
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
