break in chart scale
Most of my values range from 0 to 300, but one value is 1200. I would like to
graph the values 0 thru 300 in detail, and have a "break in the graph. After the break I would like to start a scale from 1000-1200, to graph the remaining point. Does anyone know how to do this? |
break in chart scale
Hi,
Here is a collection of examples of how to break the 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 Jill wrote: Most of my values range from 0 to 300, but one value is 1200. I would like to graph the values 0 thru 300 in detail, and have a "break in the graph. After the break I would like to start a scale from 1000-1200, to graph the remaining point. Does anyone know how to do this? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
break in chart scale
[Andy Pope] scrive in
.gbl Most of my values range from 0 to 300, but one value is 1200. I would like to graph the values 0 thru 300 in detail, and have a "break in the graph. After the break I would like to start a scale from 1000-1200, to graph the remaining point. Does anyone know how to do this? also: http://www.prodomosua.it/zips/taglio.xlt parameters: 25 (E2), 25 (E3), 13 (E5), 40 ((E6) .f |
All times are GMT +1. The time now is 08:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com