| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula used by Excel to determine y-axis interval in chart
The min and max are fairly well characterized in terms of the major tick
spacing: http://support.microsoft.com/default.aspx?kbid=214075 I have found no published information about how Excel determines the major tick spacing. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "M Chin" <M wrote in message ... Where may I find the formula used by Excel in deterining the interval for y-axis when converting data to chart |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to know the logic for determining the interval between Y axis labels | Charts and Charting in Excel | |||
| Using a formula to determine variable rows in Chart | Charts and Charting in Excel | |||
| Excel Formula to determine if cells contain certain data | Excel Worksheet Functions | |||
| What formula do I use in Excel to determine whether one cell fall. | Excel Worksheet Functions | |||
| How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
Hybrid Mode
