A pivot table might be a good approach. You need three columns: date (fill
them all in), hour, and value. Select the data, and make a pivot table (data
menu). You probably want Hour in the rows area, Date in the columns area,
and Value in the data area. But you can drag the fields around depending on
the extent of your data and how you find the analysis is proceeding.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
"charter_SKR" <(E-Mail Removed)> wrote in message
news:6CBCD93D-27B6-4895-A7E5-(E-Mail Removed)...
> Hi I have a lot of data in the following format. I need to trace the value
> of
> flag for a month.( I tried F11 thing but that chart is crowded.) sample
> data
> is given for 2 days. below. I want to come out with a neat chart that
> would
> helpme make, analyze the pattern on a daily and monthly and make decisions
> .
> Could any1 HELP!
>
>
> Day 1 Hour Value of Flag
> 3/17/2006 1 46
> 2 28
> 3 13
> 4 7
> 5 3
> 6 1
> 7 8
> 8 16
> 9 73
> 10 135
> 11 205
> 12 303
> 13 355
> 14 371
> 15 415
> 16 388
> 17 438
> 18 434
> 19 362
> 20 377
> 21 256
> 22 168
> 23 123
> 24 82
> Day 2 1 67
> 2 25
> 3 23
> 4 6
> 5 6
> 6 7
> 7 12
> 8 10
> 9 46
> 10 118
> 11 226
> 12 335
> 13 347
> 14 423
> 15 421
> 16 374
> 17 387
> 18 349
> 19 329
> 20 418
> 21 218
> 22 163
> 23 92
> 24 59
>
Similar Threads
