mcmichael13
The Wanna-Be
- Local time
- Today, 00:52
- Joined
- Apr 15, 2009
- Messages
- 50
Hey guys,
I have a couple forms with different pivot charts on them (they were the easiest to make for me). based on date selection by the user, these charts are formed, also based on the "Location", which is used as the series. the user may select to see results from both locations, or either of them separately.
the issue is arising when i set all my data how i want it, the pivot chart does not save my settings. it will erase my data labels, change fonts, etc. is there a way to control pivot charts via vba?
is there another way to do this using regular charts in a report? i'm just looking for the easiest solution.
thanks
Rob
I have a couple forms with different pivot charts on them (they were the easiest to make for me). based on date selection by the user, these charts are formed, also based on the "Location", which is used as the series. the user may select to see results from both locations, or either of them separately.
the issue is arising when i set all my data how i want it, the pivot chart does not save my settings. it will erase my data labels, change fonts, etc. is there a way to control pivot charts via vba?
is there another way to do this using regular charts in a report? i'm just looking for the easiest solution.
thanks
Rob
