Dynamic Chart Series for Pivot Table

I use pivot table and X-Y Scatter plot for analysis of data. Is it possible for scatter plot to select the chart series automatically, as I select the different pivot table fields?

I use x values as the 'Row Field', and Y values with 'Data Items'. And 'Column Field' as a different series. (Please check first figure [pivot.jpg])

Is it possible to write a macro which automatically plots
column field - as Series Name
Row field - as X values
data items - as Y values

(I have figured out how to plot X-Y Scatter plot for Pivot table, which is generally not allowed.)

Consequently, Is it possible to do that same if there are more than one column fields? (Check Figure 2 [pivot2.jpg])

I have worked with excel macros in the past. But for this particular problem, I am not able to come up with any logic so far. So, please help.

I hope that I have explained the problem clearly. Thanks.

Here is the attached sample file. Sorry for putting only pictures. Thanks.

Thank you so much Andy.

Just one more question.

When we have more than one 1 columnfields (for example, Pressure and Diameter), Is it possible for series names to be like

pressure 1 diameter 1
Pressure 1 diameter 2
pressure 2 diamater 1
Pressure 2 diameter 2

(I usually remove columns with subtotals from field setting --> subtotals --> none)

I am attaching the excel sheet with updated graph. Once again, thanks a lot.