I have a pivot table displaying the information but would like to try and display it in the manner described above if possible.
It would have the agent field along the x axis, they will have 3 bars each with each bar being one of ‘Individual Case Needs’, ‘Cases’, and ‘Clients’ with the stacked bars for each having the values for ‘required’, ‘requested’, ‘received’, and ‘unobtainable’ values.
I think you can use small multiples with a vertical bar chart. It’s not exactly what you’re looking for but it’s the closest you’ll get to it.
Put the field that contains ‘Individual Case Needs’, ‘Cases’ and ‘Clients’ on your x-axis, and put the field that contains ‘required’, ‘requested’, ‘received’, and ‘unobtainable’ in your small multiples field well, or vice-versa.
You can see an example of small multiples used with a vertical bar chart here: