Go Back  Bike Forums > The Lounge > Foo
Reload this Page >

some excel help?

Foo Off-Topic chit chat with no general subject.

some excel help?

Reply

Old 03-17-08, 07:30 PM
  #1  
dijos
Walks with a limp
Thread Starter
 
dijos's Avatar
 
Join Date: Nov 2006
Location: Indy, IN
Posts: 1,346
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 4 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
Posts: 1,675
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 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
Posts: 11,739
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 101 Post(s)
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
Posts: 13,696

Bikes: who cares?

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
transpose the data
randya is offline  
Reply With Quote

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


Thread Tools
Search this Thread

Contact Us Archive Advertising Cookie Policy Privacy Statement Terms of Service