how to create pivot charts with VBA?

  • Thread starter StevenR via AccessMonster.com
  • Start date
S

StevenR via AccessMonster.com

I am trying to create pivit charts in a subform based on a selection in a
combo box on the main form. There are 15 possible selections in the combo box
so I was wondering if there was a way in VBA to create the piviot chart in
the subform and set it up the way I want it to look for each selection in
the combo box. The chart is not visible until the user clicks a button to get
the chart. I am using Access 2002 and VBA. Thanks for any help you may be
able to provide.
 
Top