Advertise on Bikeforums.net



User Tag List

Results 1 to 4 of 4
  1. #1
    Walks with a limp dijos's Avatar
    Join Date
    Nov 2006
    Location
    St Pete
    Posts
    1,341
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    some excel help?

    I have data in a matrix; months along the top, years in the left column. I want to have a single line graph that plots the data in a month-by-month, year-by-year format. I must have set the matrix up wrong or something, because I can't sort it to make it a useable source for the graph I'm trying to make. any help?
    I am looking for a 52cm-ish lugged mixte or ladies frame. Pm if you got one.
    Quote Originally Posted by thebristolkid
    Last I checked, most college campuses were firmly attached to solid earth, which, in my experience, is typically adequate for riding a bicycle upon.

  2. #2
    Senior Member ModoVincere's Avatar
    Join Date
    Aug 2006
    Posts
    1,676
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Put the data in columns.
    Date in column 1 and the data in column2
    Then you can graph it quite easily.
    1 bronze, 0 silver, 1 gold

  3. #3
    Senior Member DannoXYZ's Avatar
    Join Date
    Jul 2005
    Location
    Saratoga, CA
    Posts
    11,507
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by dijos View Post
    I have data in a matrix; months along the top, years in the left column. I want to have a single line graph that plots the data in a month-by-month, year-by-year format. I must have set the matrix up wrong or something, because I can't sort it to make it a useable source for the graph I'm trying to make. any help?
    What you have needs to be plotted on a 3D chart, not a 2D line-graph. What you really need is overlaying two 2D line-graphs. As ModoVincere pointed out, you need to have the independent-variable across the bottom and the dependent variable on the vertical axis. Do two of these charts and overlay them.

  4. #4
    Senior Member randya's Avatar
    Join Date
    Jul 2003
    Location
    in bed with your mom
    My Bikes
    who cares?
    Posts
    13,696
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    transpose the data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •