ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Axes Breaks with Excel?? (https://www.excelbanter.com/charts-charting-excel/19023-axes-breaks-excel.html)

Felix Maus

Axes Breaks with Excel??
 
Can anyone help me to realize axes breaks with Excel? Is it possible at all?

I know that Origin can handle axes breaks easily - but I'd rather use Excel
for some applications. Please tell me if you know anything about it!

Felix



John Mansfield

Felix,

You can create the look of a broken axis - these sites illustrate how:

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

http://andypope.info/charts/brokencolumn.htm

http://tushar-mehta.com/excel/newsgr...xis/index.html

----
Regards,
John Mansfield
http://www.pdbook.com

"Felix Maus" wrote:

Can anyone help me to realize axes breaks with Excel? Is it possible at all?

I know that Origin can handle axes breaks easily - but I'd rather use Excel
for some applications. Please tell me if you know anything about it!

Felix




Andy Pope

Hi Felix,

Have a look at these examples

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://tushar-mehta.com/excel/newsgr...ial/index.html
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

Felix Maus wrote:
Can anyone help me to realize axes breaks with Excel? Is it possible at all?

I know that Origin can handle axes breaks easily - but I'd rather use Excel
for some applications. Please tell me if you know anything about it!

Felix



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Jerry W. Lewis



John Mansfield wrote:

Felix,

You can create the look of a broken axis - these sites illustrate how:

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

http://andypope.info/charts/brokencolumn.htm

http://tushar-mehta.com/excel/newsgr...xis/index.html

----
Regards,
John Mansfield
http://www.pdbook.com

"Felix Maus" wrote:


Can anyone help me to realize axes breaks with Excel? Is it possible at all?

I know that Origin can handle axes breaks easily - but I'd rather use Excel
for some applications. Please tell me if you know anything about it!

Felix







All times are GMT +1. The time now is 02:22 AM.

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