chart data by day of week

D

Dan

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.
 
D

Dan

Dan said:
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.
Click to expand...

Problem solved....
Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping large amount of data by day-of-week 3
Counting occurrence of day of week AND hour of day 6
Line Chart with dates in 5 day working week only 2
automatically base a chart on next columns each day? 7
A Picture 11
Chart showing different data than listed 3
Storing data by week 1
Calculate sales in the week by day ? 6

Top