+ Reply to Thread
Results 1 to 4 of 4

Insert break in X axis for discontinuous time

  1. #1
    Registered User
    Join Date
    08-11-2009
    Location
    Connecticut, USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Insert break in X axis for discontinuous time

    I have repeated measures of a Y variable, but no measures between weeks 36 and 52. I want to insert a break in the X axis to illustrate this discontinuous time. I don't just want to leave blank spaces for weeks 37-51, I would like to break the axis. I appreciate any suggestions!

    Anne

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,247

    Re: Insert break in X axis for discontinuous time

    Hi Anne,
    Assuming you are using an XY Scatter, you may be able to use the technique shown here for breaking a Y axis.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Insert break in X axis for discontinuous time

    FYI: thread moved from Tips & Tutorials to Charting forum.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: Insert break in X axis for discontinuous time

    If you do not want to break the X axis you could try setting the axis to Category rather than time series, assuming your x axis labels are dates.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1