Forum Discussion
Solved
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,
- 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
2 Replies
- 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 1AdamChmielewski I can confirm this worked perfectly! Thank you!
