Automate Graph of Pivot table

B

Bruce Stemplewski

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
Pivot Table Automation 1
Change Pivot Table Page Value 3
Copy paste from Excel to Outlook - Graphs, pivots & cells 1
Macro Help in Pivot 2
Storing data from pivot tables with adjacent entered data 0
Pivot Table macro - strange behaviour 1
Extracting data from external pivot table - Office 2007 0

Top