Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart data by day of week
I have a spreadsheet of 12,000 records of stolen vehicles (cars,
SUV's, pickups, motorcycles, etc.) covering a period of almost two years. Each record has a date of theft and other info about the vehicle. I'd like to look at the thefts for day of the seven day week. For instance, I'd like to look at all motorcycle thefts over a one year period and count occurances by day of week and then generate a single chart with theft count as the ordinate and day-of-the-week as the abcissa. I'm new to the group so pardon me if this question has been asked before. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart data by day of week
Dan wrote: I have a spreadsheet of 12,000 records of stolen vehicles (cars, SUV's, pickups, motorcycles, etc.) covering a period of almost two years. Each record has a date of theft and other info about the vehicle. I'd like to look at the thefts for day of the seven day week. For instance, I'd like to look at all motorcycle thefts over a one year period and count occurances by day of week and then generate a single chart with theft count as the ordinate and day-of-the-week as the abcissa. I'm new to the group so pardon me if this question has been asked before. Problem solved.... Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data showing incorrectly on line chart | Charts and Charting in Excel | |||
Chart data file lost - need to re-create from chart? | Charts and Charting in Excel | |||
Why doesn't my chart update when underlying data changes? | Charts and Charting in Excel | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |