ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Scale break (https://www.excelbanter.com/charts-charting-excel/173662-scale-break.html)

Kinky

Scale break
 
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.

Jon Peltier

Scale break
 
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.




Shane Devenshire

Scale break
 
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.




All times are GMT +1. The time now is 03:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com