G Guest Mar 9, 2006 #1 Can value axis intervals be compressed or eliminated when charting multiple series with wide value differences?
Can value axis intervals be compressed or eliminated when charting multiple series with wide value differences?
J Jon Peltier Mar 9, 2006 #2 The usual suggestions are to use a secondary axis, use a logarithmic scale, or use a hack like this to show a break in the axis: http://peltiertech.com/Excel/Charts/BrokenYAxis.html - 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 _______
The usual suggestions are to use a secondary axis, use a logarithmic scale, or use a hack like this to show a break in the axis: http://peltiertech.com/Excel/Charts/BrokenYAxis.html - 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 _______
