Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Maybe this is a better place to have posted the question.
I have a graph set up where an input starts the range you want to look at. I always want the "Y" to start at 0, and the scale nicely goes as high as necesary for the numbers in the table (viscosity). If I want to look at the 100 degree temperature range starting at 0, the x axis works fine. but if I choose to look at 50 and above, the "x" axis still starts with 0, leaving a blank graph between 0 and 50 and still stopping at 100. How can I set it so the x axis scale starts at the value selected? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Unfortunately Excel's algorithm for axis minimum nearly always gives you
zero as one endpoint. Only if the minimum and maximum differ by less than about 1/6 of the full scale will Excel move away from zero. There's no setting to undo this. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "widman" wrote in message ... Maybe this is a better place to have posted the question. I have a graph set up where an input starts the range you want to look at. I always want the "Y" to start at 0, and the scale nicely goes as high as necesary for the numbers in the table (viscosity). If I want to look at the 100 degree temperature range starting at 0, the x axis works fine. but if I choose to look at 50 and above, the "x" axis still starts with 0, leaving a blank graph between 0 and 50 and still stopping at 100. How can I set it so the x axis scale starts at the value selected? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
extend graph axis automatically in excel | Charts and Charting in Excel | |||
Bar graph and line graph overlayed | Charts and Charting in Excel | |||
Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
Scatter Graph - Data Label Problems | Charts and Charting in Excel | |||
Problem with graph ranges | Charts and Charting in Excel |