R
relampagos
I have a series of bar graphs created using the MS Office Web Components. I have added the "error bars" to the graphs, however it seems to give me only two different options for the calculations reflected in those bars - "fixed" and "percentage." In the Access 2003 help tool, it shows the formulas for both standard deviation and standard error, yet it doesn't explain how to get the error bars to reflect the values reached by either of those formulas. Any ideas? Also, I've gotten the graphs to display final values reached from queries and calculations by dropping the columns containing those values into the "data fields" area on the chart... But, I don't know how Access would even determine a standard deviation without my entire set of values in the final query which displays the graph... so maybe that's where my problem begins, but I haven't been successful getting the graph to work correctly when I have the entire series of values leading to the aggregate sum, average, or percentage, as opposed to the final values after those calculations... help, please