Autoscale Y axis in Graph

T

Tim B

I have prepared a report that displays various categories
of data some of which ranges from 0 to 10 (say, toilets
sold), some from 72 to 80 (repair kits sold),
etc...however, when I use the chart wizard, I invariably
get a 0 to max value scale on the Y axis. I want the
chart to show an appropriate minimum value for the y axis
as well as max. I have played with all the combinations
of checking and unchecking the auto scale boxes to no
avail. I have both Access 97 and Access 2000 available to
me on different PCs. HELP!
 
Top