OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

Sparkline and progress bar

  • Thread starter Thread starter Lucía Arcos
  • Start date Start date
L

Lucía Arcos

Guest
I am trying to create a progress bar based on the number of checkboxes checked: https://docs.google.com/spreadsheets/d/1MBw_W6kA2qNQaW5t1WZGuOMYpQkYlCkyTlDZ0yLCrdU/edit?usp=sharing

I have managed to create a bar but I would like to change color, that is based on all checkboxes and not only on the ones on the first column and that it shows a percentage on top of it.

I have tried this formula but it doesn't work: =SPARKLINE(COUNTIF(B5:B24;E5:E24;H5:H24;K5:K24;TRUE);{"charttype"\"bar";"color"\"#dac4b1";"max"\80})

Could you please help? Thanks

Continue reading...
 
Top