ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I change the scale of part of an axis in a graph on Excel? (https://www.excelbanter.com/charts-charting-excel/159308-how-do-i-change-scale-part-axis-graph-excel.html)

Secateurs

How do I change the scale of part of an axis in a graph on Excel?
 
I have a graph that needs to use a large scale up the top, but down the
bottom I was wondering if I could 'squash' the scale. I think it's possible
to do this in another application (Datastudio) where it inserts a 'squiggly
line' between parts of the scale it collapses/squashes.
This is in Excel 2003.
Thanks

David Biddulph[_2_]

How do I change the scale of part of an axis in a graph on Excel?
 
http://peltiertech.com/Excel/Charts/BrokenYAxis.html may help ?
--
David Biddulph

"Secateurs" wrote in message
...
I have a graph that needs to use a large scale up the top, but down the
bottom I was wondering if I could 'squash' the scale. I think it's
possible
to do this in another application (Datastudio) where it inserts a
'squiggly
line' between parts of the scale it collapses/squashes.
This is in Excel 2003.
Thanks





All times are GMT +1. The time now is 11:59 PM.

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