Foo - some excel help?

Bikeforums.net is a forum about nothing but bikes. Our community can help you find information about hard-to-find and localized information like bicycle tours, specialties like where in your area to have your recumbent bike serviced, or what are the best bicycle tires and seats for the activities you use your bike for.



PDA

View Full Version : some excel help?

dijos
03-17-08, 07:30 PM
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?

ModoVincere
03-17-08, 07:35 PM
Put the data in columns.
Date in column 1 and the data in column2
Then you can graph it quite easily.
DannoXYZ
03-17-08, 10:50 PM
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.

randya
03-17-08, 10:57 PM
transpose the data