Splitting a Graph

[John Harris]

What is the method for splitting the y axis amounts so that large ranges can
be on the same graph? I have a server storage bar graph that ranged from 1
MB to 9000 MB and would like to split it so the bars are not so small.

Thanks

JC

[Andy Pope]

Hi,

Here are some examples 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/ngs/ng30.htm

Cheers
Andy

John Harris wrote:
> What is the method for splitting the y axis amounts so that large ranges can
> be on the same graph? I have a server storage bar graph that ranged from 1
> MB to 9000 MB and would like to split it so the bars are not so small.
>
> Thanks
>
> JC
>
>

--

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

[fernando cinquegrani]

[Andy Pope] scrive in
http://www.google.it/groups?threadm=...TNGP15.phx.gbl
> Hi,
>
> Here are some examples 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/ngs/ng30.htm
>

also:
http://www.prodomosua.it/zips/taglio.xls
http://www.prodomosua.it/zips/critico.xls
[in italian]
.f