911Dispatcher7
New Member
- Joined
- Jun 4, 2020
- Messages
- 2
- Office Version
- 2010
- Platform
- Windows
I have a sheet with lots of data. Dates and call volume numbers, etc. As my username suggest, I am a 911 dispatcher so this workbook is all about COVID. I have made several line charts to show this years call volumes compared to last years. Now I want to add to this chart events. Say on Fab 1 businesses were closed, on march 1st something else happened, etc. This will help to show why the call volumes changed. I added a column to the data table to enter these events. What else do I need to do to get the events to show up on the line chart? I tried to add the new column as a new series and set it as a secondary axis but did not get the results I was looking for. I want the actual event to appear in the line chart on the date it happened.
Thanks for any and all help.
Thanks for any and all help.