A
AsianPride210
I don't know how to make a data table. Please help make one for me by tomorrow.
F
FloMM2
AsianPride210,
This is easier than you think.
Column A in cell A1 TIME,cells A2 through A62.
1:00
2:00
3:00
etc.
60:00
In column B data point that changes, cell B2 through B62 what the data point
was.
In column C second data point that changes, cell C2 through C62 what the
data point was.
Looks something like:
TIME 1st Data 2nd Data
1:00 15 121
2:00 16 122
3:00 16 107
4:00 18 201
and so on and so forth.
hth
This is easier than you think.
Column A in cell A1 TIME,cells A2 through A62.
1:00
2:00
3:00
etc.
60:00
In column B data point that changes, cell B2 through B62 what the data point
was.
In column C second data point that changes, cell C2 through C62 what the
data point was.
Looks something like:
TIME 1st Data 2nd Data
1:00 15 121
2:00 16 122
3:00 16 107
4:00 18 201
and so on and so forth.
hth
D
Debra Dalgleish
There are instructions on the Microsoft web site:
How to create and use one-input data tables in Microsoft Excel
http://support.microsoft.com/kb/282855/en-us
How to create and use one-input data tables in Microsoft Excel
http://support.microsoft.com/kb/282855/en-us
M
Max
Try also this sample from my archives:
http://savefile.com/files/46276
2 variable data table example
(full details inside, nicely rendered)
http://savefile.com/files/46276
2 variable data table example
(full details inside, nicely rendered)