Can't Set Minimum Y Axis Values

A

annem

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
 
B

Barb Reinhardt

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

HTH,
Barb Reinhardt
 
A

annem

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

Barb Reinhardt said:
When you CHECK minimum, it autoscales the minimum. Make sure it's UNCHECKED.

HTH,
Barb Reinhardt
 
P

PayPaul

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top