ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart with multiple series (https://www.excelbanter.com/charts-charting-excel/76285-chart-multiple-series.html)

officehub

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

Jon Peltier

Chart with multiple series
 
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
_______

"officehub" wrote in message
...
Can value axis intervals be compressed or eliminated when charting
multiple
series with wide value differences?





All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com