Thread: MS Excel Charting ratios
July 10th, 2012, 01:28 PM #1
- Join Date
- Jul 2012
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By mateo leet-o in forum PC ModificationReplies: 2Last Post: May 12th, 2005, 03:30 PM
By Dooin' it in forum Applications and Operating SystemsReplies: 4Last Post: March 23rd, 2005, 09:35 PM
By gambler2611 in forum General Gaming DiscussionReplies: 11Last Post: March 4th, 2005, 11:00 PM
By CyberGhost in forum General Tech DiscussionReplies: 8Last Post: October 16th, 2003, 07:27 AM
By tmx468 in forum Processors, Memory, and OverclockingReplies: 3Last Post: February 25th, 2003, 06:49 PM