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
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