View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matthew Pfluger Matthew Pfluger is offline
external usenet poster
 
Posts: 130
Default 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