Removing gap between bars in clustered column chart

[Aradhana]

Hi All,

I need to remove the gap between bars in clustered column chart. If you consider the chart below, There is a gap after first blue bar under oring category. I don't want to show this gap in the chart. Bar should be clubbed together and show 3 bars together for oring category.

Is this possible.

Thanks,

Aradhana

[v-rongtiep-msft · Accepted solution]

Hi @Aradhana ,

This is by design. The problem you are running into is that if it "skips" it without leaving the space, then the user will not know there are no duplicate counts, for example.  You might reorder the list so that the ones that don't show up often are nearer the end, but the space tells the reader of the graph that there is a column missing there.  

May be you can try to use Stacked column chart. Or create an idea here 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Aradhana , In place of legend, use both columns on axis, Sort on the axis column, Switch off -> Concatenate label and try

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

[Aradhana]

@amitchandak

But I can't add the legend column in X axis as I have time hieararchy in x axis. Requirement is like I need to show the fault code for each hierarchy level.

Thanks,

Aradhana