Linear Gauge Chart

[Anonymous]

I need to display data for 3 types of tickets per person. Currently this is being shown in a stacked bar chart but would like to show this in a linear gauge chart. I am attaching the image of the representation that is needed to be shown along side the columns i.e. Person who is resolving the tickets.. Count of tickets in 3 columns based on the ticket type and then a bar chart along side the 3 cols showing the count that shows the breakup of these tickets.

.

Can anybody help how this can be done in a linear chart instead of regular stacked chart as a stacked bar chart occupies too much of space?

I have not found a solution to show a break up of these ticket in linear gauge chart as most the gauge charts take only the full sum the tickets per person

[Gysbert_Wassenaar]

If you want to use an inline linear gauge chart in a straight table or pivot table then you need to realize that the segment settings are set at the chart level. You can't set them individually per row.

Perhaps a bar chart with the numbers inside the segments is an acceptable alternative. If you haven't done so already change the Orientation setting of the bar chart on the Style tab to Horizontal. Enable the options Values on Data Points on the Expressions tab for the expression(s). And enable the option Plot Values Inside Segments on the Presentation tab.