Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to set the minimum value of a chart?

Status
Not open for further replies.

Elminster

Programmer
Jun 26, 2001
78
CA
Hi,
In a chart, how can I set the minimum value (MinimumScale) in relation to the minimum value that I have on my chart and can I have a minimum value that is bigger than the minimum value of the chart?

I'll be grateful for any help
Thanks
 
You can set the scale when you double click on the chart in report design view. This will take you to Microsoft Graph. Click on the axis and choose format axis. There is a "scale" tab to insert the values you want. Hope this helps!
 
Well thanks for answering back ... but I already tired that and it doesn't work. It simply does nothing! I can put any value in it and the chart always start at 0. Also I try in VB to force the automatic scale with ".MinimumScaleIsAuto = True" but that also doesn't seem to work.

Anyway, I have a minimum value that change often, so I can't put a fix value.

once again, thanks for helping
Regards
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top