Filter chart

1) Scatter chart isn't available for Pivot Charts. You could plot regular chart based on pivot table range using intermediate table/range. But I'm not sure what you want to plot as x axis (date isn't normally used in category axis of scatter plot). If it's date, I'd recommend using Text() function to use dates as fixed category.

2) You can change Values aggregation method by clicking on the field (in field selection pane), and using "Value Field Settings". For grouping, you can right click on the row label, and choose "Ungroup" to show individual dates.

0.JPG

If you need bit more help, manually create sample scatter plot that you want to show and upload. It isn't clear to me what end result you are trying to achieve here.

Here you go.

1. Add Named Range for Pivot Range.
pvtRng

Formula:

Please Login or Register  to view this content.

2. Create intermediate data table (LinkedPvt!M1:O15) Extend range as needed.
In M1:

Formula:

Please Login or Register  to view this content.

Copy down and across.

3. Add named ranges for chart series formula using same concept. See Serie1_..., Serie2_... & h_axis named ranges in attached.

Replace Series 1 (OUTFLOW) formula with...

Formula:

Please Login or Register  to view this content.

Adjust as needed.

See attached.

Anything more dynamic, will either require more named ranges to be set up, or will require use of small vba code.