ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Broken x-axis in excel (https://www.excelbanter.com/charts-charting-excel/141844-broken-x-axis-excel.html)

KE

Broken x-axis in excel
 
Hi.

I want to create a chart, where my x axis contains values within a range
above zero, and to a given value. So far so good.

My problem involves that i want the axis itself to show that there is a
break from zero to my given value (marked with a Z-like sign), wich excel
does not automaticly do. Is this possible to acheive? I have seen charts vith
this prefix, but there is no such function, or description of how to do it in
the "help register".

Thank you.
--
ketil

Jon Peltier

Broken x-axis in excel
 
This page shows one approach, and links to a couple others:

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

It deals specifically with a Y axis, but if the X axis is a value axis
(i.e., it's an XY chart) the protocol is very similar.

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


"KE" wrote in message
...
Hi.

I want to create a chart, where my x axis contains values within a range
above zero, and to a given value. So far so good.

My problem involves that i want the axis itself to show that there is a
break from zero to my given value (marked with a Z-like sign), wich excel
does not automaticly do. Is this possible to acheive? I have seen charts
vith
this prefix, but there is no such function, or description of how to do it
in
the "help register".

Thank you.
--
ketil





All times are GMT +1. The time now is 09:51 PM.

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