Scale my function for a line graph
June 12, 2013 7:23 AM Subscribe
Math-filter: I have a line chart in Google Docs that plots three columns of data over time. Data in the first two columns ranges from 0-1000, but data in the third column ranges from 3-9. I'd like to "scale" Line 3 (maybe this is the wrong word?) to be able to compare its value over the same graph space as Lines 1 and 2.
I think what I need to do is create a new, "scaled" column and plot that as Line 3 instead. Thus, in this scaled column, I believe 9 unscaled would be the same as 1000 scaled, and 3 would be the same as 0. Since this is a spreadsheet, I need something in the form y=f(unscaled Column 3 value).
That's all I've got, though, after half an hour of trying to remember my algebra, and then another fifteen minutes playing with Wolfram Alpha. Am I on the right track here? What's the function to scale Line 3?