+ Reply to Thread
Results 1 to 6 of 6

How to get 4 positive quadrants in xy scatter graph

  1. #1
    Registered User
    Join Date
    07-14-2011
    Location
    India, Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    3

    How to get 4 positive quadrants in xy scatter graph

    Hi,

    How to get 4 positive quadrants in xy scatter graph?

    For this graph X & Y value are the average value and min value will be more than zero.

    I XY scatter the quadrants always start for Zero.

    Please help.

    Thanks

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,614

    Re: How to get 4 positive quadrants in xy scatter graph

    Righ click on each Axis numbers and in xxxxx axis croses write minimum number (or 0) of your graph.
    is that it?

  3. #3
    Registered User
    Join Date
    07-14-2011
    Location
    India, Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: How to get 4 positive quadrants in xy scatter graph

    Quote Originally Posted by zbor View Post
    Righ click on each Axis numbers and in xxxxx axis croses write minimum number (or 0) of your graph.
    is that it?
    Hi,

    I have done all those things....... if do this the mid point wiil start form zero... then i will get only one quadrant

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

    Re: How to get 4 positive quadrants in xy scatter graph

    If you are after a vertical/horizontal line to divide up your plot area why not add another series and specify the points to describe where you want the lines to cross.

    If you need more help post example file.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    07-14-2011
    Location
    India, Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: How to get 4 positive quadrants in xy scatter graph

    Quote Originally Posted by Andy Pope View Post
    If you are after a vertical/horizontal line to divide up your plot area why not add another series and specify the points to describe where you want the lines to cross.

    If you need more help post example file.
    Hi Andy Pope,

    Attached is a screen shot for your reference. Here all the quadrants are positive.
    Attached Images Attached Images

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

    Re: How to get 4 positive quadrants in xy scatter graph

    Use Zbor's instructions but enter the value you want to cross at and not minimum or zero
    Attached Files Attached Files

+ 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