Plotting drilled-down data from pivot table

[jlt199]

Morning,

You know when you double click on a cell in a pivot table to drill down to the relevant data. I would like to do this and then plot two of the columns from this drilled down data set as a scatter chart.

Is there a way I can do this automatically, without having having to create a new worksheet, and have the chart automatically update with the use of the pivot table slicers?

I've spent a long time googling, but either it can't be done, or I can't get the terminology right in my search.

Many thanks

[jlt199]

I've added an example data file to my first post

[avk]

Refer attach file "Pivot" Sheet.
As i am assuming you want this.