| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date in First Column, Time in First Row
I have data correlated to date and time. The dates go down the first column
of the sheet and the times (hours of each day) go across the first row of the sheet, like so: 01:00 02:00 03:00 ... 01/01/05 1.3 2.2 3.2 ... 01/02/05 5.2 4.2 1.7 ... 01/03/05 2.3 4.1 6.4 ... .. .. .. How do I make a chart with Date and Time on the x-axis and data on the y-axis without doing lots of copying and pasting? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| search for latest date | Excel Worksheet Functions | |||
| Count cells based on date range in another column | New Users to Excel | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
Threaded Mode
