+ Reply to Thread
Results 1 to 4 of 4
  1. 08-11-2009, 03:23 PM #1
    anne.black@yale.edu
    anne.black@yale.edu is offline
    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
    Reply With Quote Reply With Quote
  2. 08-12-2009, 04:11 AM #2
    romperstomper
    romperstomper is offline
    Forum Moderator romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    Alibi
    MS-Off Ver
    All
    Posts
    8,262

    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.
    So long, and thanks for all the fish.
    Reply With Quote Reply With Quote
  3. 08-12-2009, 04:42 AM #3
    DonkeyOte
    DonkeyOte is offline
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,379

    Re: Insert break in X axis for discontinuous time

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

    Volatility
    Sumproduct & Arrays
    Pivot Intro
    Email from XL - VBA & Outlook VBA
    Function Dictionary & Function Translations
    Dynamic Named Ranges
    Reply With Quote Reply With Quote
  4. 08-12-2009, 05:05 AM #4
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,944

    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 With Quote Reply With Quote
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0