+ Reply to Thread
Results 1 to 2 of 2

Scatter Plot Problems

  1. #1
    Registered User
    Join Date
    02-18-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Angry Scatter Plot Problems

    I am creating a scatter plot and my x-axis is percent moon illuminated and my y-axis is deer observed. I have values like (0, 180) that are plotted along my y-axis. How can I make it so that the y-axis does not intersect the x-axis at zero so I don't have values plotted along the y-axis?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,814

    Re: Scatter Plot Problems

    Not sure I understand exactly what is wrong. It sounds like you need to do something with the horizontal (value) axis formatting options for the x axis: http://office.microsoft.com/en-us/ex...255.aspx?CTT=1 (I know the help file claims to be for the vertical (value) axis, but you need to recognize that, in a scatter plot, the horizontal axis is also a value axis and has the same formatting options available)

    If I understand what you want, you either need to change the minimum value for the axis and/or change the "vertical axis crosses at" parameter(s) to move the vertical axis relative to the data.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Converting Scatter plot to Line plot and back
    By SPDavern in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-26-2015, 10:49 AM
  2. Excel 2010 - X Y scatter plot will not plot empty cells as gap
    By bjeffers0306 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-12-2013, 12:56 AM
  3. Replies: 2
    Last Post: 07-26-2012, 09:27 AM
  4. Excel 2007 : VBA XY scatter plot problems
    By jordan_schultz in forum Excel General
    Replies: 3
    Last Post: 05-31-2009, 07:46 AM
  5. Converting XY Scatter plot to Line Plot and back
    By SPDavern in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2005, 10:06 PM

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