ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   extended y-axix (https://www.excelbanter.com/charts-charting-excel/172897-extended-y-axix.html)

John

extended y-axix
 
Do you know of a method in excel to condense the y-axis such that you still
use zero as the origin when your data is centered on, say, 5,000,000?


Jon Peltier

extended y-axix
 
You mean this?

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

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


"John" wrote in message
...
Do you know of a method in excel to condense the y-axis such that you
still
use zero as the origin when your data is centered on, say, 5,000,000?





All times are GMT +1. The time now is 11:17 AM.

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