If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|