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.
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.
