Can't Set Minimum Y Axis Values
 

Sounds simple, but I can't get my simple line graph to accept a change in the
Minimum Y axis value. Here's the data. I want the minimum Y value to be
90. I go to format the Y axis and check the Minimum box and set at 90. I
hit OK and the scale is the same. Thanks, Anne M
Reading Date Time
184 19-Jul Fasting
246 25-Jul Fasting
205 26-Jul Fasting
197 27-Jul Fasting
164 27-Jul Bed Time
173 28-Jul Fasting
144 28-Jul Post Brkfst
166 29-Jul Fasting
172 30-Jul Fasting
140 31-Jul Fasting
161 1-Aug Fasting

Can't Set Minimum Y Axis Values
 

When you CHECK minimum, it autoscales the minimum. Make sure it's UNCHECKED.

HTH,
Barb Reinhardt

"annem" wrote:

Sounds simple, but I can't get my simple line graph to accept a change in the
Minimum Y axis value. Here's the data. I want the minimum Y value to be
90. I go to format the Y axis and check the Minimum box and set at 90. I
hit OK and the scale is the same. Thanks, Anne M
Reading Date Time
184 19-Jul Fasting
246 25-Jul Fasting
205 26-Jul Fasting
197 27-Jul Fasting
164 27-Jul Bed Time
173 28-Jul Fasting
144 28-Jul Post Brkfst
166 29-Jul Fasting
172 30-Jul Fasting
140 31-Jul Fasting
161 1-Aug Fasting

Can't Set Minimum Y Axis Values
 

How simple and dumb of me. Many Thanks. Anne M

"Barb Reinhardt" wrote:

When you CHECK minimum, it autoscales the minimum. Make sure it's UNCHECKED.

HTH,
Barb Reinhardt

"annem" wrote:

Sounds simple, but I can't get my simple line graph to accept a change in the
Minimum Y axis value. Here's the data. I want the minimum Y value to be
90. I go to format the Y axis and check the Minimum box and set at 90. I
hit OK and the scale is the same. Thanks, Anne M
Reading Date Time
184 19-Jul Fasting
246 25-Jul Fasting
205 26-Jul Fasting
197 27-Jul Fasting
164 27-Jul Bed Time
173 28-Jul Fasting
144 28-Jul Post Brkfst
166 29-Jul Fasting
172 30-Jul Fasting
140 31-Jul Fasting
161 1-Aug Fasting

Can't Set Minimum Y Axis Values
 

I've noticed that even when I uncheck the auto check box in this the numbers
change over to something else when I go back to the dialog box to change the
numbers again. Why is that? I don't understand how the scale numbers work.
Most times I get a mish mash of values on the left hand side of the graph.
The data information is crammed all together that is. How do I find what the
correct scale numbers are to plug into the minimum and maximum boxes?

Thanks,

Paul

"annem" wrote:

How simple and dumb of me. Many Thanks. Anne M

"Barb Reinhardt" wrote:

When you CHECK minimum, it autoscales the minimum. Make sure it's UNCHECKED.

HTH,
Barb Reinhardt

"annem" wrote:

Sounds simple, but I can't get my simple line graph to accept a change in the
Minimum Y axis value. Here's the data. I want the minimum Y value to be
90. I go to format the Y axis and check the Minimum box and set at 90. I
hit OK and the scale is the same. Thanks, Anne M
Reading Date Time
184 19-Jul Fasting
246 25-Jul Fasting
205 26-Jul Fasting
197 27-Jul Fasting
164 27-Jul Bed Time
173 28-Jul Fasting
144 28-Jul Post Brkfst
166 29-Jul Fasting
172 30-Jul Fasting
140 31-Jul Fasting
161 1-Aug Fasting