Extracting Nested PivotItems

M

Matthew Pfluger

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top