Access 2003 MS Office Web Components !HELP!
I am doing some reporting using Access 2003, with the "Data Access Page" and I am running into a few issues.
(1) The error bars are great... but I need them to reflect standard deviation, not "fixed" or "percent," which are the only two options I seem to have.
(a) I think this may be a result of the graph only pulling data from already-calculated fields, instead of doing the aggregate work for averages and sums and things like that - I was unable to get that to work, so I did all calculations in queries prior to feeding them to the Office Charting tool.
(2) Second, there is conditional formatting optional for the bars of the graph... but what about the numbers that reflect their values or the font-color in an Excel chart which you can insert as well? Conditionally coloring the bars makes it somewhat unreadable, and all I'd like to do is color either the numbers reflecting the bars' values, or color the corresponding cells in the Excel Sheet below the Office Chart conditionally based upon their values.
(3) Lastly, I have a need to adjust the scale and axis values based on what kind of data I'll be sending in. I know these objects have IDs and have altered XML code after they're saved, but what if I want to change those values dynamically based on the range of the values in my database? In other words, these reports are to be automatically generated, and I don't want to have unnecessary whitespace on the graph, and I most certainly don't want a part of it cut off. I'd like to limit those values, and also be able to define the points of major/minor axes on the fly so the graph has optimal readability.
I know I have a lot of detailed questions here, but if you can offer any help with any of them, it would be greeeeeeeeeatly appreciated. Thanks!
