Closed Thread
Results 1 to 2 of 2

Charting is getting me down

Hybrid View

scottintexas Charting is getting me down 12-29-2008, 08:13 PM
shg Scott, Please start a new... 12-29-2008, 09:10 PM
  1. #1
    Registered User
    Join Date
    05-22-2008
    Posts
    74

    Charting is getting me down

    I am getting stupid. Excel 2007 doesn't seem to let me do the charting I was once able to do. In Column A I have data values for mile values recorded from the satellite. In column B I have values recorded from the odometer. I want to chart the curve that represents satellite miles VS Odometer miles.

    Sat Truck
    116.30 111.10
    168.70 161.10
    195.80 187.00
    206.30 197.00
    210.00 200.60

    As you can see it's not linear and I wanted to have excel develop the curve calculation for me. It's been 15 years since my calculus class. What I keep getting is two lines with the Y axis being satellite miles and the X axis going being the row numbers 1 through 5. Do you see what I want? I hope someone can help.

    Here's what I want to do. I need to figure out what the equation is to give me actual miles (Satellite) for any given odometer reading. My tires are bigger than factory and I want actual miles for gas calculations. I know it's a curve just by looking at the data. But since it has been 15 years since my last calculus class I am getting lost here. If I drive 15 miles odometer reading what is the actual miles driven? If I have the data charted can't excel apply a trend line and give me an equation?

    Thanks for your help.
    Last edited by scottintexas; 12-29-2008 at 09:06 PM. Reason: More detail that could prove helpful
    Scott
    The harder it gets the happier I am.
    Finally got my signature set up!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Scott,

    Please start a new thread with a descriptive title.
    Entia non sunt multiplicanda sine necessitate

Closed Thread

Thread Information

Users Browsing this Thread

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

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