E
emunsing
I'm using Office 2003 in a medical device field to manage a quality assurance
database. The engineers who will be using the database need to know the
statistical significance of all data, and it is standard to show all charts
with standard deviation, percentile, or max/min plots.
I'd like to be able to make a PivotChart view that gives this information,
but have not been able to find a way of displaying custom error bars
calculated for each data point (as is possible for static charts in Excel, by
selecting a data range for the "Custom" error bar data fields). This problem
extends to Excel pivotcharts - if anyone knows how to answer the problem for
either, that would be great.
I'd be looking to automate any solution, so that as the user plays with the
PivotChart fields, error bars are automatically generated for the displayed
series. A macro-driven solution to this would also be acceptable- anyone
know of how to really take control of the error bars using a macro, and how
to have the fields used in a macro interfacewith a pivotTable?
database. The engineers who will be using the database need to know the
statistical significance of all data, and it is standard to show all charts
with standard deviation, percentile, or max/min plots.
I'd like to be able to make a PivotChart view that gives this information,
but have not been able to find a way of displaying custom error bars
calculated for each data point (as is possible for static charts in Excel, by
selecting a data range for the "Custom" error bar data fields). This problem
extends to Excel pivotcharts - if anyone knows how to answer the problem for
either, that would be great.
I'd be looking to automate any solution, so that as the user plays with the
PivotChart fields, error bars are automatically generated for the displayed
series. A macro-driven solution to this would also be acceptable- anyone
know of how to really take control of the error bars using a macro, and how
to have the fields used in a macro interfacewith a pivotTable?