ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I create a zig zag representing omitted values? (https://www.excelbanter.com/charts-charting-excel/150048-how-do-i-create-zig-zag-representing-omitted-values.html)

bjroho52

How do I create a zig zag representing omitted values?
 
How do I create a zig zag line that represents omitted values on the x or y
axes?

ShaneDevenshire

How do I create a zig zag representing omitted values?
 
If you mean you want to indicate that part of the x or y axis is not being
displayed - there is no built in way to do this but you can check:

http://peltiertech.com/Excel/Charts/axes.html#Broken

--
Cheers,
Shane Devenshire


"bjroho52" wrote:

How do I create a zig zag line that represents omitted values on the x or y
axes?


Wigi

How do I create a zig zag representing omitted values?
 
Andy Pope has it on his website too.

http://www.andypope.info, then go to the (quite impressive) charting area.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"ShaneDevenshire" wrote:

If you mean you want to indicate that part of the x or y axis is not being
displayed - there is no built in way to do this but you can check:

http://peltiertech.com/Excel/Charts/axes.html#Broken

--
Cheers,
Shane Devenshire


"bjroho52" wrote:

How do I create a zig zag line that represents omitted values on the x or y
axes?



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

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