SOLVED

# Creating a chart/graph on the total of highlighted, conditionally formatted cells?

Copper Contributor

# Creating a chart/graph on the total of highlighted, conditionally formatted cells?

I have a series of data in a table, example below:

It is formatted so that if the completion date is more than 3 months before the deadline, it highlights green, and less than 3 months highlights red.

I need to create a bar chart and a pie chart to show just the number of red and the number of green. How would I achieve this?

Thanks,

2 Replies
best response confirmed by EGrant475 (Copper Contributor)
Solution

# Re: Creating a chart/graph on the total of highlighted, conditionally formatted cells?

Add a new column called something like "isCompleted" with a 0/1 value or true/false
You can then easily reference this for the bar or pie charts.
You can as well have the formatting based on this value instead of having the logic in the conditional formatting. The conditional formatting would be just check if the value next is a 0 or 1

# Re: Creating a chart/graph on the total of highlighted, conditionally formatted cells?

@AdamChmielewski  I can confirm this worked perfectly! Thank you!

1 best response

Accepted Solutions
best response confirmed by EGrant475 (Copper Contributor)
Solution

# Re: Creating a chart/graph on the total of highlighted, conditionally formatted cells?

Add a new column called something like "isCompleted" with a 0/1 value or true/false
You can then easily reference this for the bar or pie charts.
You can as well have the formatting based on this value instead of having the logic in the conditional formatting. The conditional formatting would be just check if the value next is a 0 or 1