Fixed Scale on Line Graph 2

[JJOHNS]

I have a graph in a report. The X Axis is a date range. No problem there. The Y Axis is a weight range. If I way myself every day, you can see any fluctuations in my weight over time. If, on the other hand, my girlfriend weighs herself every day, the increments on the Y Axis will be different for her than for me. What my supervisor wants is a fixed weight range and increments on the Y Axis (min 50, max 450, with 10 pound increments, for example). This would give a better visual representation of weight fluctuations when comparing two persons of different sizes.

Is it possible? I've looked through five books and found nothing.

 

[GingerR]

yes. i have done this.
do you have one chart on the report?
how do you select the two people to compare?
do you ever select more people to compare?
at this point do you just get separate charts, one at a time -- i'm guessing so. how do you plan on getting a chart and before opening the report choose "Compare To : " and select someone else? or do you have a report with two charts on it (half-page each) just for this 'comparison' reason?

i had a similar situation but i have three charts on one page. i determined which was the highest dollar amount i was displaying, determined which chart that would be in, then used the Y-axis values from that chart for the other two charts.

once you let me know answers to above i can help more.
the functions i used were in vba, in the Report's detail section's OnFormat property (and it's not that hard so dont worry):
Me.Chart1.axes(2).maximumscale = MaximumScaleToUse
Me.Chart1.axes(2).MajorUnit = MajorUnitFormat

MaximumScaleToUse and MajorUnitFormat are my own variable.
i set all min scales to zero, but you can use .minimum scale too.

in any case, give answers and we'll get on it.
g

 

[JJOHNS]

Ginger,

Thanks for replying. I now realize I was not very clear with my question. There is only one chart on a page. What happened is this: A medical inspector came to my hospital. He held up a report on one patient and was impressed by how we were tracking weight fluctuations. Then he held up a report on a second patient and just about panicked because it looked like the person had lost a lot of weight. Someone had to show him that the increments on the Y Axis were different for each patient's report, and this person had actually only lost three pounds.

When I talked about comparison, I meant just by holding two reports in your hands and looking at them.

If I can fix the Y Axis to one weight range and 5 or 10 pound increments, then we won't have inspectors panicking.

 

[GingerR]

well you can do it manually if you want. is that what you mean? it will be set then for ever patient.

go into the design of the chart (double-click on it)
double-click on the Y axis
choose the SCALE tab
enter any values you wish.
any ones you want your way, should be unchecked. then Access Graph won't try to figure them out automatically for you depending on the data in the chart.


is this what you wanted?