LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 70
Default Analysing time and days patterns in a chart

Hi there

What do you think would be best chart format to analyse some data that
consists of:
Date of Call out
Day of call out
Time Of Call out
Call out Reference

I am trying to see if there is any pattern in the days & times of call outs
to improve rosters.

Basically I want the time of callout & day of week mapped across
dates/months to see any trends.
For example if Fridays at 1am are a recurring callout time (after the pub!)
or every other Friday etc.

Do yo uthink Pivot tabe and charts is relevant or can normal chart provide
me with the results?

Many thanks
 
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
Were non-gradient chart patterns left out of Excel 2007? Arthur Tabachneck Charts and Charting in Excel 2 August 28th 07 01:58 AM
Are the non-gradient chart patterns missing from Excel 2007? Art[_3_] Excel Worksheet Functions 1 August 27th 07 10:37 PM
analysing companies - help!! therum Excel Discussion (Misc queries) 2 April 1st 07 01:06 AM
Analysing data through pivot Chris Excel Discussion (Misc queries) 3 January 9th 06 03:39 PM
Calculating days & time left from start date/time to end date/time marie Excel Worksheet Functions 7 December 7th 05 02:36 PM


All times are GMT +1. The time now is 10:29 PM.

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

About Us

"It's about Microsoft Excel"