| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change tick mark labels in z axis from values to texts? | Charts and Charting in Excel | |||
| how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Chart Axis Scale Auto Values | Charts and Charting in Excel | |||
| How to find the minimum value in a database with multiple values . | Excel Discussion (Misc queries) | |||
Hybrid Mode
