ExcelBanter - Scale on Axes

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Scale on Axes (https://www.excelbanter.com/charts-charting-excel/191165-scale-axes.html)

Ali

Scale on Axes

Is there a way to have 2 scales on one axis?
ie. if one values range from -100 to +30 want the minus to be smaller scale
so that the positive values which are the ones I am really interested in are
not made so small?
--
Ali
UK

Andy Pope

Scale on Axes

Hi,

Maybe you can use the broken axis technique for the negative part of the
scale.
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

Ali wrote:
Is there a way to have 2 scales on one axis?
ie. if one values range from -100 to +30 want the minus to be smaller scale
so that the positive values which are the ones I am really interested in are
not made so small?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

All times are GMT +1. The time now is 04:20 AM.