4 Replies Latest reply on May 17, 2017 11:05 PM by rishabh kumar

    Shapes to replace the bar chart

    rishabh kumar

      Hi,

       

      I am trying to replace the bar chart with circles which will represent percentage. The graph with circle should be in such a way that the % should show in a colored circle and the remaining (100-%) should show as grey.

       

      I am using Index() function but that is not helping. I have also used below formula to replace the bar graph but that is also not helping.

       

      If INDEX()-1<=INT(WINDOW_SUM(SUM([Rate]))/100)

      THEN

      INDEX()*100

      END

       

      I have included my workbook and the screenshot of how the chart should come up.

      Please assist. Thank you.