High bars
 

In Bar Charts, when values (height) of a or a few bars are very higher than
others, maximun of y-axis is very high than general values. Therefore general
bar heights become very short. Is it possible to show these high bars by
cutting and adjusting y-scale.

High bars
 

Hi,

Here are some work arounds for splitting the Y axis.

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://tushar-mehta.com/excel/newsgr...ial/index.html
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

AhmtDY wrote:
In Bar Charts, when values (height) of a or a few bars are very higher than
others, maximun of y-axis is very high than general values. Therefore general
bar heights become very short. Is it possible to show these high bars by
cutting and adjusting y-scale.

--

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