Bar Chart Showing Number of Test Cases by Assignee


Hi :)

I'd like to create a bar chart showing the number of test cases by assignee that I can present on a Dashboard. I can do this if I know who the Assignees are (can do a COUNTIF) however, at this stage, I don't know who will be executing the tests.

Is there a way of setting this up so the chart updates automatically based on the sheets containing the test cases?

I'm wanting something like this example, from google search:



Best Answer