Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PIvotitems visible | Excel Programming | |||
PivotItems Bug?! | Excel Programming | |||
Adding PivotItems | Excel Programming | |||
Always keep the same 4 PivotItems visible | Excel Programming | |||
Add PivotItems to PivotTable / Enabling - Disabling PivotItems | Excel Programming |