Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting X and Y axis'
Is there someway of getting the scale option that allows for minimum and
maximum on both the X and Y axis? Right now, the option is only on the X and the Y scale wants to know where to cross. -- Very Thankful |
#2
|
|||
|
|||
Joey -
You can set the min and max of the axes without worrying about where they cross. Double click an axis, and on the Scale tab enter whatever values you want. Then don't check the Auto boxes, because that tells Excel to override your values and use its own automatically determined defaults. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Joey041 wrote: Is there someway of getting the scale option that allows for minimum and maximum on both the X and Y axis? Right now, the option is only on the X and the Y scale wants to know where to cross. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting X Axis Source Data | Charts and Charting in Excel | |||
Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) | |||
Formatting of x axis | Excel Discussion (Misc queries) | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |