I am trying to make a chart with bars consisting of values from 11 to
5500. There is only the one value above 1300. When you in the same
chart have values 11 and 5500 it is very hard to see the lower values.

Is there anyway to interrupt the scales at e.g. 1500 and then start
again at 5000. Thereby skipping the values in between.

Thanks in advance.


--
renehp
------------------------------------------------------------------------
renehp's Profile: http://www.excelforum.com/member.php...o&userid=37221
View this thread: http://www.excelforum.com/showthread...hreadid=569329

Hi,

See this page for examples and links to others
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

renehp wrote:
I am trying to make a chart with bars consisting of values from 11 to
5500. There is only the one value above 1300. When you in the same
chart have values 11 and 5500 it is very hard to see the lower values.

Is there anyway to interrupt the scales at e.g. 1500 and then start
again at 5000. Thereby skipping the values in between.

Thanks in advance.



--

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