Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Dan Dan is offline
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Dan Dan is offline
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data showing incorrectly on line chart gobonniego Charts and Charting in Excel 1 June 15th 06 07:56 PM
Chart data file lost - need to re-create from chart? LostExcelData Charts and Charting in Excel 1 June 7th 06 07:54 PM
Why doesn't my chart update when underlying data changes? Marc Charts and Charting in Excel 3 November 19th 05 05:31 PM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"