ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   charting extreme number differences on x-axis (https://www.excelbanter.com/charts-charting-excel/185436-charting-extreme-number-differences-x-axis.html)

MacGyver@IFC

charting extreme number differences on x-axis
 
I've seen cahrts where the X axis has 2 slashes to represent gaps in the
numbers where extreme ranges of data is charted. how do I do that?

Jon Peltier

charting extreme number differences on x-axis
 
This shows how to do it for the Y axis; the X axis uses a similar approach.
It's really just a hack:

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

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


"MacGyver@IFC" wrote in message
...
I've seen cahrts where the X axis has 2 slashes to represent gaps in the
numbers where extreme ranges of data is charted. how do I do that?





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

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