Can a pivot cache be based on one data series of a pivot table in vba?

I need to create a pivot chart for each data series in the pivot table.

I think I need to create separate pivot caches from the pivot table.  Is this correct?

In the attached file I need to create a pivot chart for each grade.
PivotTableReport-20130107-124948.xlsx
Union-method-CreateChartExcel201.txt
kkhan7Asked:
Who is Participating?
 
Mark WillsTopic AdvisorCommented:
No, don't think you do need separate caches. Well, that assumes they can use the same data source.

Have a read of : http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_11752-How-do-I-separate-PivotTables.html  Also has some VBA example code...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.