| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate Graph of Pivot table
I have a Pivot Table that gets created on the fly so it contains unknown
columns and rows: Pencil Pen Fred 10 20 Sally 100 0 John 50 30 I want to set Data Range of my graph so that I graph on Person and Item Type. How can I retrieve the range in my PivotTable for person, Item (Pencil Pen) and quantity? I was unable to find anything on Pivot Tables in Excel VB help. -- Bruce E. Stemplewski www.caribedreamin.com www.stempsoft.com http://ICQ#: 176599859 wwp.icq.com/176599859 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Graph | Excel Discussion (Misc queries) | |||
| Automate pivot table selection | Excel Discussion (Misc queries) | |||
| Automate Pivot Table to only 1 Item | Excel Discussion (Misc queries) | |||
| Graph with pivot table | Excel Discussion (Misc queries) | |||
| Automate Pivot Table Drill down | Excel Worksheet Functions | |||
Linear Mode
