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