Can anyone tell me how to have a "break" in a column chart in order to show a
large difference in scale? Using log scale works but doesn't visually
exhibit the compelling difference in scale that a "break" in one of the
columns would show. Thanks for the help.

This page describes one way, and has links to a couple mo

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

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


"Kinky" wrote in message
...
Can anyone tell me how to have a "break" in a column chart in order to
show a
large difference in scale? Using log scale works but doesn't visually
exhibit the compelling difference in scale that a "break" in one of the
columns would show. Thanks for the help.

Hi,

We have been asking Microsoft for this for years, let's keep our fingers
crossed, maybe the next version. Of course in the meantime look at Jon's
stuff.

Cheers,
Shane

"Kinky" wrote in message
...
Can anyone tell me how to have a "break" in a column chart in order to
show a
large difference in scale? Using log scale works but doesn't visually
exhibit the compelling difference in scale that a "break" in one of the
columns would show. Thanks for the help.