Cycling and bicycle discussion forums. 
   Click here to join our community Log in to access your Control Panel  


Go Back   > >

Foo Off-Topic chit chat with no general subject.

User Tag List

Reply
 
Thread Tools Search this Thread
Old 03-17-08, 07:30 PM   #1
dijos
Walks with a limp
Thread Starter
 
dijos's Avatar
 
Join Date: Nov 2006
Location: St Pete
Bikes:
Posts: 1,341
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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?
dijos is offline   Reply With Quote
Old 03-17-08, 07:35 PM   #2
ModoVincere
Riding Heaven's Highways on the grand tour
 
ModoVincere's Avatar
 
Join Date: Aug 2006
Bikes:
Posts: 1,675
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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
ModoVincere is offline   Reply With Quote
Old 03-17-08, 10:50 PM   #3
DannoXYZ 
Senior Member
 
DannoXYZ's Avatar
 
Join Date: Jul 2005
Location: Saratoga, CA
Bikes:
Posts: 11,600
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
DannoXYZ is offline   Reply With Quote
Old 03-17-08, 10:57 PM   #4
randya
Senior Member
 
randya's Avatar
 
Join Date: Jul 2003
Location: in bed with your mom
Bikes: who cares?
Posts: 13,689
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
transpose the data
randya is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -6. The time now is 01:45 PM.