J
JamieMac
Access 2003 has pivotcharts that allow the user to fit trendlines to the data
which display the trendline's equation and the R-squared value. However,
these values are automatically displayed on the chart at the end of the
trendline. Often, the equation and R-squared values are on top of each other
or on top of datapoints. This is especially true if you plot multiple lines.
Unlike Excel, Access does not allow you to move the equations or R-squared
values out of the way. They are in a fixed location. Also, you cannot add a
text box to the pivotchart. Unless someone knows of a work-around... these
problems severely limit the utility of plotting data in Access pivotcharts.
which display the trendline's equation and the R-squared value. However,
these values are automatically displayed on the chart at the end of the
trendline. Often, the equation and R-squared values are on top of each other
or on top of datapoints. This is especially true if you plot multiple lines.
Unlike Excel, Access does not allow you to move the equations or R-squared
values out of the way. They are in a fixed location. Also, you cannot add a
text box to the pivotchart. Unless someone knows of a work-around... these
problems severely limit the utility of plotting data in Access pivotcharts.