Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: can you put breaks in y axis?

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Newfoundland
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    can you place breaks in the y-axis? If not directly, any way to trick excel into doing it?

    thanks

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Rustycar,

    I don't believe there is a way to break an axis--I assume you mean a discontinuity--with Excel charts. However, you can make it appear to be a single chart with broken axis by actually overlaying two charts that have exactly the same x-axis scale, then setting the y-axis scales for the two charts separately to provide the discontinuity. Remove the x-axis from the chart with the higher y-axis values and move it up above the other charts, and bring it forward so it is on top of the other. By removing the background fill from the topmost chart the bottom chart can show through. You will also need to remove the border from the topmost chart.

    I hope this is enough to get you going.
    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •