Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Vs Chart
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Vs Chart
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use data from different worksheets to create a chart | Charts and Charting in Excel | |||
Why doesn't my chart update when underlying data changes? | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |