+ Reply to Thread
Results 1 to 5 of 5

Thread: Line markers further spaced

  1. #1
    Registered User
    Join Date
    04-28-2011
    Location
    San Francisco, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Line markers further spaced

    Hello --

    How do I get line markers in a scatterplot spaced further apart?

    Thanks,
    Sarah

  2. #2
    Forum Guru darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Colorado, US
    MS-Off Ver
    2007
    Posts
    2,170

    Re: Line markers further spaced

    Select the axis, right-click, choose Format Axis..., then under Axis Options, change the major unit to whatever you want it to be. The default is Auto.
    Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.

    If you like a post, please rate it with the scales icon (top right).
    If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.

  3. #3
    Registered User
    Join Date
    04-28-2011
    Location
    San Francisco, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Line markers further spaced

    I wasn't clear. Please excuse me. I'm not interested in making the axis tick marks further apart, I'm interested in making line markers further apart. So if I have a line in a scatterplot and I've designated it by a black line with + sign markers, how do I make those markers farther apart?

  4. #4
    Forum Guru darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Colorado, US
    MS-Off Ver
    2007
    Posts
    2,170

    Re: Line markers further spaced

    Now I'm confused. The only lines I'm aware of in scatterplots (axis lines aside), are trendlines. Any chance of a dummy workbook showing the issue? (If someone else reading this is more familiar with scatterplots and wants to jump in, feel free.

    Edit: I now see what you mean, I think. You can follow the same steps as I gave you above, except edit the minimum and maximum rather than the major unit. That should space the tickers out further, if I understand your requirements.
    Last edited by darkyam; 11-17-2011 at 03:55 PM.
    Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.

    If you like a post, please rate it with the scales icon (top right).
    If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    11,351

    Re: Line markers further spaced

    Could it be you have used the line chart style rather than xy-scatter.
    Line charts have equal spacing between x category values, unless they are dates.

    If you still need help post example workbook to illustrate your problem
    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)

Tags for this Thread

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.2.0