4 Replies Latest reply on Jul 12, 2018 6:26 AM by Phung Le

    Showing missing values on axis for a continuous date

    Nathan Masters

      Hi

      Hoping that someone could help me find a way to ensure that I always show a 12 month range on the x axis for a bar chart.

      As per below, the full 12 month range is showing with November blank.

       

      However, if there is data missing for multiple periods outside of the start/end range for data points, I get the following:

       

       

      How do I show all periods on the axis even if there is no data? in other words, I want to ensure that the above chart is displayed as Jan to Dec with no bars (i.e all 12 periods).

       

      Thanks for your help.

       

      Regards

       

      Nathan