Thread: how do I break the y axis in a chart

I have a column chart with 0-400 on the Y axis, and only two or three columns
out of about fifteen that go to around 400, with the rest staying down below
ten. I want to put those little squiggle breaks in the long columns and on
the Y-Axis that tell people that the column is a lot longer than shown, but
has been shortened for convenience sake and to show up the shorter columns.
Does anyone know how to do that?

Thanks

Here's a technique, as well as links to a couple others:

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"mrpewty" <mrpewty@discussions.microsoft.com> wrote in message
news:7FCAE42D-1185-47AD-9558-7C81F81723E0@microsoft.com...
>I have a column chart with 0-400 on the Y axis, and only two or three
>columns
> out of about fifteen that go to around 400, with the rest staying down
> below
> ten. I want to put those little squiggle breaks in the long columns and on
> the Y-Axis that tell people that the column is a lot longer than shown,
> but
> has been shortened for convenience sake and to show up the shorter
> columns.
> Does anyone know how to do that?
>
> Thanks
>