Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


Creating a chart based on cell colour in a column

  • Finn Roberts
  • Topic Author
  • Offline
  • New Member
  • Nouveau membre
2 months 1 week ago #1351 by Finn Roberts
Hi all,

I have a spreadsheet with two key columns, a name and a date. The date columns will go red if the date falls too far behind, orange if it is approaching red and green if recently passed.

Would there be a way to create a chart that shows how many cells are red, orange and green based solely on the cell colour? All I've managed to find on google is how to change the colour of the chart based on cell colour! Any assistance would be greatly appreciated

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo