juddymar58
Programmer
Hi, I have been searching and can't seem to get this working.
I have a ms access bar graph which has a list of tasks on the y axis. The x axis shows the percentage completed of each task (value between 0-100)
I'm trying to set the maximum value of the x axis to display 100 and the scale in increments of 10 (as its a percentage it will never be greater than 100).
As per the attached file it if there isn't a task which isn't 100% complete the scale doesn't go all the way to 100.
I have been trying to set it via vba
Me!graphDesignProgress.Axes(1).MaximumScale = 100
But keep getting an error message so I think I'm on the wrong track
If the solution can be done with vba what code should I be using and where do I call the code from, is it the chart 'On Updated' event?
Any advice appreciated
Thanks
Justin
I have a ms access bar graph which has a list of tasks on the y axis. The x axis shows the percentage completed of each task (value between 0-100)
I'm trying to set the maximum value of the x axis to display 100 and the scale in increments of 10 (as its a percentage it will never be greater than 100).
As per the attached file it if there isn't a task which isn't 100% complete the scale doesn't go all the way to 100.
I have been trying to set it via vba
Me!graphDesignProgress.Axes(1).MaximumScale = 100
But keep getting an error message so I think I'm on the wrong track
If the solution can be done with vba what code should I be using and where do I call the code from, is it the chart 'On Updated' event?
Any advice appreciated
Thanks
Justin