Extracting Nested PivotItems
 

I created a PivotTable from a dynamic range. The range has three columns:
Pressure, Load, and Deflection. I placed Pressure and Load in the Row Area
in that order. Deflection is the only data item.

I want to use the PivotTable to get a unique list of Pressures and then
graph the Deflection vs. the Load. So, for each unique Pressure, create a
series of Loads (X variable) and Deflections (Y variable).

How can I get the Load and Deflection data that correspond to a Pressure? I
figured out how to use PivotTableObject.PivotItems to get the list of
Pressures, but I can't figure out how to access the related Load and
Deflection.

I appreciate the advice. Thanks.
Matthew Pfluger