+ Reply to Thread
Results 1 to 2 of 2

Graph in excel

  1. #1
    Registered User
    Join Date
    06-20-2016
    Location
    Tajikistan
    MS-Off Ver
    2010
    Posts
    1

    Graph in excel

    Hello, this might not be a first time people ask this question, but here I a

    My sample size is 400 Ph results of soil test. The data ranges from from 5.0 to 8.3. Ph of soil should be 6.0 to 7.0 for growing some crops. With the graph I would like to display number points that do not fall under optimal Ph range. What is the way to display graph in excel that shows data sets that deviate from Ph norms? i.e 6.0-7.0.

    I was able to display data in scatter plot but wasn't able to set "boundary" that shows limits.


    Thanks in advance folks,

    Davron

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Graph in excel

    The best way to do this is to create another column that references the pH values and includes each given value only if it is outside the range 6-7, then use that as the data series for the graph.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Replies: 1
    Last Post: 08-27-2015, 01:54 AM
  2. Replies: 0
    Last Post: 10-03-2014, 07:51 AM
  3. Replies: 0
    Last Post: 09-15-2014, 02:01 AM
  4. Replies: 3
    Last Post: 09-14-2012, 11:59 AM
  5. Replies: 2
    Last Post: 08-29-2011, 12:29 PM
  6. Replies: 6
    Last Post: 01-25-2006, 02:45 PM
  7. [SOLVED] Hyperlinkage of one graph with another graph or Drill down graph
    By Sanjay Kumar Singh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-03-2006, 08:25 AM

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.6.0 RC 1