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" <(E-Mail Removed)> wrote in message
news:7FCAE42D-1185-47AD-9558-(E-Mail Removed)...
>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
>

I have the same problem and found this link to be quite a long process and
for a very dated version of Excel. Any tips for creating a break in the
verticle axis with 2007? Thanks.

"Jon Peltier" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:7FCAE42D-1185-47AD-9558-(E-Mail Removed)...
> >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
> >
>
>
>

The protocol works in Excel 2007. Things haven't advanced that far in ten
years. The process is long because it requires a fairly major workaround,
and there isn't much you can do to shorten it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"rslaughter5" <(E-Mail Removed)> wrote in message
newsC8F2AB4-C3F5-4379-A225-(E-Mail Removed)...
>I have the same problem and found this link to be quite a long process and
> for a very dated version of Excel. Any tips for creating a break in the
> verticle axis with 2007? Thanks.
>
> "Jon Peltier" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:7FCAE42D-1185-47AD-9558-(E-Mail Removed)...
>> >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
>> >
>>
>>
>>