Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating a bar graph manually
I work for an ambulance service. I wish to track, via a horizontal bar
graph, the call times. Here is how it would be set up: Cells A1 through AZ1 (as example) equals times (text format to get 4 digits for time without dropping leading zero), ie A1=0600, B1=0601, C1=0602, D1=0603...AZ1=1800 (military time). I know I need more cells than A1-AZ1, but just an example Cells A2 - A10 siginfiy which ambulance unit, ie A2=Medic 1, A3=Medic 2, etc Somewhere in the spreadsheet, I have a section that I enter the dispatch times and the end time of each call. Lets say column BA1:BA10 equals start times and BB1:BB10 equals stop times. What I want to do is have the chart section created by the times 0600 - 1800 and ambulance number (Medic 1, Medic 2, etc) fill in appropriately the timeslot for each call. So if Medic 1 was on a call from 0605 to 0700, the cells for Medic 1 under those times would fill in. I know this will be a conditional formatting, but not sure how to have those cells reference the start/stop array in order to know whether to fill in or not. Any cells that were not filled in would indicate when the unit was not on a call. Below is an example of the above, but I use X's to represent the color fill for a cell |0600|0601|.....| 0607| 0608| 0609|....| 0615| 0616|....| 0700| Medic 1 | | | |XXXX|XXXX|XXXX|XX|XXXX|XXXX|XX|XXXX| Any help greatly appreciated, Thanks, Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a combination graph with stackedColumns+lineGraph | Charts and Charting in Excel | |||
Graph Help- 12 month graph, but only want months that have passed | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Creating a line graph from 2 pivot tables? | Charts and Charting in Excel | |||
creating a directed graph from XY scatter | Charts and Charting in Excel |