1 Reply Latest reply on Nov 3, 2016 7:20 AM by Michael Hesser

    Creating Gauge Chart

    KS RAO

      Hi

       

      I want to create the below Gauge Chart as per the below data an d conditions

       

         

      CategoryActual Value  Target        ValueProduct Achieved
      All Products30.94667.17%
      Phones25.63182.58%
      Furniture3.81231.67%
      Envelops2.1452.50%

       

       

       

      Formula:

      Product Achieved=Actual Value/Target Value

       

      Color Coding:

         

      1.If Product Achieved below 50% then Red color and 50%-100% then Yellow and above 100% means Green Color

      2.Each dot is showing in Gauge chart 10 units

       

       

      Please help me on this ASAP.

       

      Thanks in Advance.