Stacked Bar Chart - Multiple Bars

Question & Answer
,
1

Hi,

Is there anyway to have a visual that is a stacked bar chart but allows for multiple bars grouped by the x axis values.

Screenshot_20230207_105559
Screenshot_20230207_1055591281×348 36.6 KB

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.

Any help would be greatly appreciated, thank you.

Riley

2

You can’t display all of that on one bar chat. You can look into actions / drilldowns that take you from your highest level and go deeper.

3

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: