Status Complete Chart
I am trying to create a chart on a dashboard indicating percent completed. Essentially I have a project where 2 companies need to complete a task for each location. What I have:
-A master sheet of all the companies and their locations
-A form to enter data
-A lookup to the master sheet from the form data indicating if that location is complete or not
I can't figure out how to represent this in a chart. This would preferably be a pie for each company using the master sheet of "Complete" and "Not Complete". Any thoughts or other methods to do this?