Thread: MS Excel Charting ratios
-
July 10th, 2012, 01:28 PM #1Junior 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
-
fan ratios
By mateo leet-o in forum PC ModificationReplies: 2Last Post: May 12th, 2005, 03:30 PM -
Excel help!! I fight Excel & Excel wins!!!!!!!!!
By Dooin' it in forum Applications and Operating SystemsReplies: 4Last Post: March 23rd, 2005, 09:35 PM -
CS: source ratios
By gambler2611 in forum General Gaming DiscussionReplies: 11Last Post: March 4th, 2005, 11:00 PM -
can anyone please explain ratios to me?
By CyberGhost in forum General Tech DiscussionReplies: 8Last Post: October 16th, 2003, 07:27 AM -
Ratios
By tmx468 in forum Processors, Memory, and OverclockingReplies: 3Last Post: February 25th, 2003, 06:49 PM



LinkBack URL
About LinkBacks



Reply With Quote

Best wishes for your wife, TP. I hope it all turns out OK.
Is It Just Me? v233893843