Forum Discussion

D_Varghese's avatar
D_Varghese
Copper Contributor
Oct 18, 2022
Solved

Create a time slot graph

Hello! I was hoping to find some help with this issue. I manage a clinic and wanted to plot data that showed the following information:   Date No of patients Start time - End time.   For exampl...
  • SnowMan55's avatar
    SnowMan55
    Oct 19, 2022

    D_Varghese 

    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.

Resources