Log in  \/ 
x
or
x
x
Register  \/ 
x

or

unanswered Creating a chart based on cell colour in a column

More
1 year 2 months ago #1351 by FinnRoberts
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.

Moderators: jaychivoExcelfansqiuhongkun