Chart with multiple series

Guest · Mar 9, 2006

Can value axis intervals be compressed or eliminated when charting multiple
series with wide value differences?

Jon Peltier · Mar 9, 2006

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
_______

adding trendline to plots from multiple series	1	Jan 8, 2010
Plotting multiple data series in a bubble chart	1	Aug 22, 2007
how to select multiple data series in a chart?	1	Nov 5, 2009
Chart changes series when copied	1	Oct 2, 2009
Pivot Chart Time Series work around?	1	Feb 18, 2010
Chart type for machine timing diagram?	3	Nov 14, 2009
Placing an arrow on the series line in a line chart	5	Feb 13, 2010
Chart SERIES OFFSET	3	Jan 23, 2013

Ask a Question