Chart each hour over a 12 month span

Hello

I recently received this request and was wondering which chart to use to be able to get all the data visible

How about we do four graphs::
1. Total arrival by hour (i.e. ESI 1+2+3+4+5)
2. Arrival by hour for each ESI (as you have broken out here but with the correct numbers)
3. Arrival by hour for ESI 4 and 5
4. Arrival by hour for ESI 1,2,3

Can you provide the above 4 graphs for the entire year (i.e. each graph would cover one year’s time).


She is trying to capture the arrival of patients into the ED by hour by acuity (how severe the patient is) over the span of a year, but she wants it on one chart. The only way I could think of was to have a separate chart for each individual month. Any help would be appreciated..

Thank you

For specific help you should post a sample workbook (fake data) with a few manual examples and clear details on requirements.

Have you considered a Pivot Table/Chart?

This may be of interest: Dynamic and Interactive Charting