Hide 2nd Dimension Value if Null in Bar/Combo Chart?

[nihhalmca]

Hi All,

How To Hide 2nd Dimension Value if Null in Bar/Combo Chart?

Please find attachment, here

Thanks you,

Regards,

Nihhal.

[mdmukramali]

Dear Nihhal,

you mean want to remove the spaces between the bar if's null?

and in this type of scenario it's better to use Stacked chart

[jagan]

Hi Nihhal,

I think it is not possible to remove spaces between bars when values are null, by default the x is splitted into equal parts, so the  best option is to choose Stacked option.

Hope this helps you.

Regards,

Jagan.

[SunilChauhan]

you could make it stack and remove  the cluster distance and bar distance @ presentation tab of chart properties

see the attched file

hope this helps