M
M Skabialka
I have a chart on a form which reflects data based on some selections by the
user. The range of values can be small (1-10), or large (38000-70000) or
whatever the user requests. The data reflects actual and predicted values
over several months in the past and the future. At the point at which today
is on the chart, I need a line that goes from the top of the chat to the
bottom. If I select the highest data value in order to draw this today
line, access divides the vertical access into major units that usually
exceed this value. e.g. my highest value is 97 - access gives me a maximum
of 120, divided into units of 20. The line for today then goes up to my max
value of 97 and stops. I want it to go all the way to the top of the chart,
whatever value that happens to be, in this case 120, which is six major
units of 20.
In another test I got 5 major units of 1000. Without knowing the size of
the major unit, I am not sure what value to make for today which will draw
the line up to the maximum chart value.
Any ideas?
Mich
user. The range of values can be small (1-10), or large (38000-70000) or
whatever the user requests. The data reflects actual and predicted values
over several months in the past and the future. At the point at which today
is on the chart, I need a line that goes from the top of the chat to the
bottom. If I select the highest data value in order to draw this today
line, access divides the vertical access into major units that usually
exceed this value. e.g. my highest value is 97 - access gives me a maximum
of 120, divided into units of 20. The line for today then goes up to my max
value of 97 and stops. I want it to go all the way to the top of the chart,
whatever value that happens to be, in this case 120, which is six major
units of 20.
In another test I got 5 major units of 1000. Without knowing the size of
the major unit, I am not sure what value to make for today which will draw
the line up to the maximum chart value.
Any ideas?
Mich