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

    Shapes to replace the bar chart

    rishabh kumar



      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)





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

      Please assist. Thank you.