software

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?

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

peltiertech.com/Excel/Charts/BrokenYAxis.html

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

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

quot;Jon Peltierquot; wrote:

gt; Here's a technique, as well as links to a couple others:
gt;
gt; peltiertech.com/Excel/Charts/BrokenYAxis.html
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;mrpewtyquot; gt; wrote in message
gt; ...
gt; gt;I have a column chart with 0-400 on the Y axis, and only two or three
gt; gt;columns
gt; gt; out of about fifteen that go to around 400, with the rest staying down
gt; gt; below
gt; gt; ten. I want to put those little squiggle breaks in the long columns and on
gt; gt; the Y-Axis that tell people that the column is a lot longer than shown,
gt; gt; but
gt; gt; has been shortened for convenience sake and to show up the shorter
gt; gt; columns.
gt; gt; Does anyone know how to do that?
gt; gt;
gt; gt; Thanks
gt; gt;
gt;
gt;
gt;

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.
PeltierTech.com/WordPress/
_______quot;rslaughter5quot; gt; wrote in message
news
gt;I have the same problem and found this link to be quite a long process and
gt; for a very dated version of Excel. Any tips for creating a break in the
gt; verticle axis with 2007? Thanks.
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; Here's a technique, as well as links to a couple others:
gt;gt;
gt;gt; peltiertech.com/Excel/Charts/BrokenYAxis.html
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services
gt;gt; Tutorials and Custom Solutions
gt;gt; PeltierTech.com/
gt;gt; _______
gt;gt;
gt;gt; quot;mrpewtyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a column chart with 0-400 on the Y axis, and only two or three
gt;gt; gt;columns
gt;gt; gt; out of about fifteen that go to around 400, with the rest staying down
gt;gt; gt; below
gt;gt; gt; ten. I want to put those little squiggle breaks in the long columns and
gt;gt; gt; on
gt;gt; gt; the Y-Axis that tell people that the column is a lot longer than shown,
gt;gt; gt; but
gt;gt; gt; has been shortened for convenience sake and to show up the shorter
gt;gt; gt; columns.
gt;gt; gt; Does anyone know how to do that?
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;