| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis automatically defaults to zero
When using the automatic scale for graphs sometimes it defaults to zero even
when the data spread is fairly narrow - why ? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
X axis automatically defaults to zero
This is just how Excel calculates the minimum and maximum scale. They have
an article about this, which explains how it calculates the min and max, but not the major unit. http://support.microsoft.com/?kbid=214075 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "FBI" wrote in message ... When using the automatic scale for graphs sometimes it defaults to zero even when the data spread is fairly narrow - why ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
| Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
| can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
Linear Mode
