How to dynamically set the lower and upper limits of the axes on a MSAccess xy-chart.

B

biker

Does anybody know if there is a way to dynamically set the lower and
upper limits of the axes on a MS Access xy-chart using the underlying
minimum and maximum values in the data series used to build that
chart?

I have a chart acting as a subform in a main form. The subform is
linked to the main form by a date field. So when the main form shows a
particular day, the subform shows only the data series for that
particular day in the chart. Now I would like to set the minimum and
maximum values of the xy-chart's axes scaling in such a way that on
each day the minimum and maximum values of the axes are dynamically
set according to the minimum and maximum values of the data series of
that particular day. In this way the chart area will be used much more
efficiently than when using automatic scaling.

I would like to know if this is somehow possible within MS Access.

Any help would be very much appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top