Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with a chart in Excel
I have an excel database that has entries by date with a time associated with
each entry. I need to create a monthly line chart that shows the number of incidents in a time range, i.e. 0000-0159, 0200-0359, 1200-1359, etc. What the chart will show will be the time range where the most entries are made. I am at a loss as to how to start. Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with a chart in Excel
NEHicks wrote:
I have an excel database that has entries by date with a time associated with each entry. I need to create a monthly line chart that shows the number of incidents in a time range, i.e. 0000-0159, 0200-0359, 1200-1359, etc. What the chart will show will be the time range where the most entries are made. I am at a loss as to how to start. Thanks, The FREQUENCY function is made-to-order for obtaining such distributions. To use it you will have to create a little infrastructure first, like creating the time "buckets" you want to tally (see F1 on FREQUENCY), and probably converting decimal times to human-readable form. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Setting up and Configuration of Excel | |||
Excel 2003: How to nudge a chart element or shape on a chart? | Charts and Charting in Excel | |||
Chart Titles not showing in excel chart Window | Excel Discussion (Misc queries) | |||
Excel chart - how to assign the file name in the chart title? | Charts and Charting in Excel |