Progress Meter based on yes/no responses

Does anyone know how to create a progress meter based on yes/no (completed/not completed) responses? If 2/10 responses are completed, then the progress meter would display 20% or 20% of the bar would be red. Is this even possible in excel? I've used conditional formatting to create a progress meter but can't figure out how to make a progress bar based on responses.

Thanks.