+ Reply to Thread
Results 1 to 1 of 1
  1. #1
    Junior Member
    Join Date
    Jul 2012
    Posts
    1

    MS Excel Charting ratios

     
    I am trying to chart ratios between two numbers where if one number is larger it produces a negative ratio rather than a fraction of 1 (in other words, if a>b, then a/b; if b>a, then b/a). However, this means there are never any values between 1 and -1. When you graph it, data sets that cross from positive to negative become distorted because they show a movement of two integers when the move is actually quite minimal in certain cases (from -1.1 to positive 1.1 is really a very minor change). Is there a way to simply eliminate the range from -1 to 1 from the graph?
    Last edited by RWCrouch; July 11th, 2012 at 05:07 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. fan ratios
    By mateo leet-o in forum PC Modification
    Replies: 2
    Last Post: May 12th, 2005, 03:30 PM
  2. Excel help!! I fight Excel & Excel wins!!!!!!!!!
    By Dooin' it in forum Applications and Operating Systems
    Replies: 4
    Last Post: March 23rd, 2005, 09:35 PM
  3. CS: source ratios
    By gambler2611 in forum General Gaming Discussion
    Replies: 11
    Last Post: March 4th, 2005, 11:00 PM
  4. can anyone please explain ratios to me?
    By CyberGhost in forum General Tech Discussion
    Replies: 8
    Last Post: October 16th, 2003, 07:27 AM
  5. Ratios
    By tmx468 in forum Processors, Memory, and Overclocking
    Replies: 3
    Last Post: February 25th, 2003, 06:49 PM

Tags for this Thread

Posting Permissions

  • You may post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Recommended Sites: ResellerRatings Store Reviews