Chart Scales

[Drew]

I was wondering if there is a way to create a break in the
scale of an axis. For example, if column A = 100; column
B = 150; column C = 125; and column D = 10,000. How can I
display a chart that will have the y-axis' scale go from 0
to 200 in small increments and then have a squiggle
(meaning not to scale) and then have the axis end with
10,000. In doing so, one can see the fluctuation between
columns A thru C while still realizing the magnitude of
column D. Currently, column D, due to the abnormally
large number, distorts the chart and one can't see the
fluctuation between A and C (unless the chart is enormous).

 

[Jon Peltier]

Drew -

Excel doesn't offer this capability, but you can work around it. See my
technique here:

http://www.geocities.com/jonpeltier/Excel/Charts/BrokenYAxis.html

and Tushar Mehta's Broken Y Axis Tutorial here:

http://tushar-mehta.com

- Jon