Data Vs Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
_______
 
Back
Top