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,
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, Read More