H
Heather Vernon
I have built a rather extensive database for storing data collected from
studies. I'd like to automatically generate charts from various complex
cross-tab queries from the data based on user input. The charts need to be
user-modifable (change colors, titles, series, type) and copiable. I would
like recommendations on what approach to take.
I have preliminarily explored creating MS Charts vs. Pivot Charts in forms.
Although I can get the MS Charts to look like what I want, I have determined
that MS Charts would not fit my needs because the user cannot easily copy and
paste into another application, or modify the chart properties (like in
Excel). I do not have much exprience with Pivot Charts, but it looks like it
would be difficult to automate these since my recordset structure is very
variable. Not to mention the fact that changing series settings, legend
settings, etc. is very painful and I can't even figure out how to change the
axes titles (which could just be that I don't know much about Pivot Charts);
in short, I feel like I don't have enough control in Pivot Charts.
The only other option I can think of is exporting to Excel workbooks and
automatically creating graphs there. But I'm trying to avoid involving
another application.
Any thoughts would be appreciated.
studies. I'd like to automatically generate charts from various complex
cross-tab queries from the data based on user input. The charts need to be
user-modifable (change colors, titles, series, type) and copiable. I would
like recommendations on what approach to take.
I have preliminarily explored creating MS Charts vs. Pivot Charts in forms.
Although I can get the MS Charts to look like what I want, I have determined
that MS Charts would not fit my needs because the user cannot easily copy and
paste into another application, or modify the chart properties (like in
Excel). I do not have much exprience with Pivot Charts, but it looks like it
would be difficult to automate these since my recordset structure is very
variable. Not to mention the fact that changing series settings, legend
settings, etc. is very painful and I can't even figure out how to change the
axes titles (which could just be that I don't know much about Pivot Charts);
in short, I feel like I don't have enough control in Pivot Charts.
The only other option I can think of is exporting to Excel workbooks and
automatically creating graphs there. But I'm trying to avoid involving
another application.
Any thoughts would be appreciated.