Howdy folks - first post! Couldn't find the answer to this in the forums, and not sure I can even ask it right, but here goes.
I have a spreadsheet similar to this:
Site 1 YES YES
Site 2 NO YES
Site 3 YES NO
I'd like a visualization / horiz bar chart that would simply show each site, with the two years as sub-groupings under each site, then a solid 100% bar that was either red for NO or green for YES. Or any variation, I'm open, but I'm getting stuck on the YES/NO fields simply getting counted, which doesn't help me (unless I convert the YES's to 0 and NO's to 1 or something).
Any thoughts on how to approach this? Let me know if I can clarify or explain in more detail.