ExcelBanter - Splitting a Graph

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Splitting a Graph (https://www.excelbanter.com/charts-charting-excel/29534-splitting-graph.html)

John Harris

Splitting a Graph

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=...GP15.phx.g bl
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

All times are GMT +1. The time now is 01:10 AM.