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 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?
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?
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.
SnowMan55 You have been very helpful. I do have one more question. Is there a way to show a break between weeks to highlight the weekend? 5 columns, break, 5 columns and so forth.
Thanks