[SOLVED] Can I use a split scale on a value (Y) axis?

[deswork]

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?

[R.VENKATARAMAN]

yes see Tushar Methta's page


"deswork" <[email protected]> wrote in message
news:[email protected]...
> 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]

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" <[email protected]> wrote in message
> news:[email protected]...
>
>>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