Changing y axis range and intervals

[LARiot]

Is there anyway to modify the y axis range and interval on a report.

In case this effects the answer the class is MSGraph.Chart.8 used in Access 2003.

Thanks.

 

[dhookom]

I create a similar chart in Excel. Turn on the macro recorder and manually set the properties you would like to later automate. Turn off the macro recorder and find the generated code. You can copy and paste the code into your report. You must then modify the code to reference the chart control on your report.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[LARiot]

Actually turns out you can do this by right clicking on the chart selecting Chart Object | Edit. Right click on the axis itself select format axis. Choose the Scale tab from the top and modify records accordingly.

 

[LARiot]

Actually turns out you can do this by right clicking on the chart selecting Chart Object | Edit. Right click on the axis itself select format axis. Choose the Scale tab from the top and modify accordingly.

 

[dhookom]

I assumed you were looking to do this dynamically with some code at run-time. I should have asked first... ;-)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[LARiot]

No worries, thanks for answering. It's much appreciated.