How do I break the value (Y) axis in an Excel chart ??
 

I'm trying to shorten the Y axis on an Excel chart by breaking it. Is there
a way of doing this outside of pasting a text box and inserting two diagonal
lines (which don't stay attached to the chart when you move it!)?

Jon Peltier has instructions, and links to a couple of other techniques:

http://www.peltiertech.com/Excel/Cha...okenYAxis.html

JimP wrote:
I'm trying to shorten the Y axis on an Excel chart by breaking it. Is there
a way of doing this outside of pasting a text box and inserting two diagonal
lines (which don't stay attached to the chart when you move it!)?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html