totalbeginner
New member
- Local time
- Today, 13:29
- Joined
- Aug 24, 2009
- Messages
- 1
hello all,
i am totally new in access (2003) and don't know how to preserve the format of my pivot graph (known problem, i know). As it is a bubble chart I couldn't find any information (book or internet - seems that not a lot of people use it) and i hope you can help me or give me some hints.
My pivot chart form is based on a query.
Is there some kind of a "standardised" vba or macro code to format a bubble chart every time the report is opened? Or is there a macro which creates a bubble chart out of a pivot table?
(i.e. define the chart as bubble chart, define the x-,y- and bubble-values, define the scale, title and axis names)
I am not a proficient VBA-programmer, but I programmed in other languages, so I should be able to modify a code, once I have the basics.
THanks very much in advance (sorry if there are any spelling mistakes, I'm not a native english speaker
)
i am totally new in access (2003) and don't know how to preserve the format of my pivot graph (known problem, i know). As it is a bubble chart I couldn't find any information (book or internet - seems that not a lot of people use it) and i hope you can help me or give me some hints.
My pivot chart form is based on a query.
Is there some kind of a "standardised" vba or macro code to format a bubble chart every time the report is opened? Or is there a macro which creates a bubble chart out of a pivot table?
(i.e. define the chart as bubble chart, define the x-,y- and bubble-values, define the scale, title and axis names)
I am not a proficient VBA-programmer, but I programmed in other languages, so I should be able to modify a code, once I have the basics.
THanks very much in advance (sorry if there are any spelling mistakes, I'm not a native english speaker
)
