How do I reference the active chartspace of a pivotchart in VBA?

G

Guest

I want to create several procedures in VBA to reformat (lines, series, and
labels) in a pivotchart and to then export the chart to a gif format from MS
Access.
The "me" operator does not seem to work for the chartspace object. My
question is then -- "How do I reference the current or active chartspace?"
 
G

Guest

I should clarify that I am working directly from queries to create the
pivotcharts and that I would like to have call my formating and exporting to
gif rountines from macros available on my pivotchart tool bar. Since the "Me"
operator only works for the forms collection, my question then is how do a
reference a specific chart/workspace from within a vba module in this
situation?
 

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

Reference PivotChart view properties? 6
OWC PivotChart in Access Report 15
Syntax for changing chart in report 1
How do I get the subset filter string from a pivotchart? 1
pivotchart to image! how do I do it. found in help, not working 1
How do I adjust&save the PivotChart format? 2
creating a chart in a form 1
Change name of labels in a PivotChart 4

Top