Change PivotChart View Axis Scale Min and Max

S

ScottyMcGill

I have a Sub Form that shows my data in ChartView. As all the data is
different I need to set the X-Axis scale to automatic. The problem with this
is that Access does not do a great job, and sets my minimum value to 0. I
would prefer to have my minimum a function of the smallest value being
charted. ie [Min Record]*.9

Can I us VB or anthing else to set the X-Axis Min and/or Max? Please help
 

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

Similar Threads

adjust axis range and major units in xy-chart to data series values 0
Axis formatting 0
Time Scales on Horizontal Axis - Excel Charts 1
different value for setting with breakpoint vs regular running code 2
How to put same scale on X and Y axis on graph 2
Trying to find additional ranges outside of min, max, and average 2
How do I automate the minimum and maximum x scale? 1
Time scale on x Axis What am I doing wrong? 1

Top