Forum Discussion
Create a time slot graph
Save your workbook first, because it can be tricky to back out the following change if you don't like the results.
To change the formatting of the X (horizontal) axis, click the chart to give it focus, then click the X axis values such that you see them surrounded by a box. Right-click there to see the context menu, and click "Format Axis..." on that menu. You will get a tool section slide in from the right of the chart:
Click on the "> Labels" section to expand it, and click the radio button for "Specify interval unit" (if necessary), and change the number in the adjacent input box.
I also experimented today with user-controlled monthly and weekly summaries; see the attached workbook.
Thank you for your response. I appreciate you trying to help me out! I am trying to plot what our daily hours of operations are and denote the patient load for that day. That way, our physicians can see what the patient load is on a given day and how late we are treating. I manually enter the data in "start time", "end time" and "number of patients".
Yes, so if those data are in columns A through E, and if you can use columns F and G for the data to be plotted, the formula in column F might be:
=TEXT(A2,"mm/dd") & " " & TEXT(B2, "h:mm AM/PM") & " - " & TEXT(C2, "h:mm AM/PM")and the formula in column G simply:
=E2Copy those formulas down as needed, and you are ready to create the graph.
If you are trying to also plot "how late we are treating [patients]", which seems to be time-of-day vs. date, you can do something very similar by using two columns of 1) the date (converted to text) and 2) the end time. Here I chose a bar chart instead of a line chart:
Thank you SnowMan55 for all your help! I ended up with a histogram which is really helpful!
Do you have any suggestions on how I can get the horizontal axis to automatically adjust or set different filters to show weekly, monthly etc?
- Can you give an example of what you mean by "get[ting] the horizontal axis to automatically adjust"?
And if summarizing the daily data to weekly/monthly/etc., are the start and end times to be included, and if so, how (e.g., earliest start time to latest end time)?- Right now it displays every other day on the horizontal axis. How would I get it to show every Monday? or adjust the frequency?