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