And just in case the OP is not familiar with Tushar's site here is the link.

http://tushar-mehta.com/excel/newsgr...ial/index.html

and some alternatives.
http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

R.VENKATARAMAN wrote:
yes see Tushar Methta's page


"deswork" wrote in message
...

If the maximum of one data point is much greater than that of all the

other

data points, is is possible to split the scale on the Y axis, so I can
enlarge the lower data points and still show the max of the largest data?




--

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