ACCESS Pivot Chart Axis Title
Hi, I have built a Pivot Table using VBA for my Access DataBase.
when i open my pivottable and click on the pivot Chart view. i can view the table in a Chart View. but the "Axis Title" remains undefined.
May I know how to define them in VBA? so when i open my pivot table and transform it to pivot chart view, all the Axis are well labeled.
Thanks.
Re: ACCESS Pivot Chart Axis Title
In Excel, record a macro of you doing the renaming of the axis label. Then check out its generated code and modify to your needs.