Hello all
Thank you in advance for taking the time to read my post.
I have a very long spreadsheet in which I have multiple locations in column A, Region in column B, a date in column C and a RAG Status in column D. (see attached mock sheet)
What I am after is a clever way to display in a chart format if possible (please note that I am looking at approx. 300 or so locations) when a location has changed its status. I don't necessarily need all of the locations on the same graph as that will be pretty messy, maybe have them grouped by Region? Happy to receive any advice/direction on this.
Really appreciate the help. New job and want to make the best impression possible.
Cheers
Bookmarks