1 Reply Latest reply on Jan 7, 2019 3:42 AM by Naveen B

    Help to create a bullet chart

    Kamin Au

      Hello,

       

      I need to use aggregated data to create over 30 simple bullet charts comparing last 12 months with previous 12 months, or, year 2018 compared with 2017.

       

      Please see attached the sample workbook. I would like to change this as per my annotations shown below. In addition, it would be great to colour code to indicate whether the current period is higher or lower than the prevsiou period.

       

      Would appreciate any help on this, thank you!