Remove Spaces between bars in bar chart

[nagarajupinnibo]

Hi,

I had created a bar chart which contains spaces between bars. I need to remove spaces and combine bars.

I attached a document for it..

Even I changed cluster distance and bar distances also, but spaces are not removed

Please look at this document and provide solution for it..

Thanks,

-Nag

[#2]

Check Suppress when value is Null in Dimension tab

[nagarajupinnibo]

Hi Neha,

I already checked it. But, spaces are not removed..

[#4]

Hi,

Can you upload sample document..

Thanks

[nagarajupinnibo]

Hi Sathiyasarathy,

I attached sample document and Excel file.. When you open document, u can see spaces between bars.. needs to merge bars and remove spaces.

[#6]

Hi,

Might be something like attached.

[nagarajupinnibo]

Hi Shyamal,

In document, dimension b values merged with dimension a values.. But, I need dimension a values gets merged, dimension b values gets merged separately.

Thanks

-nag

[semperaugustus]

I think that it's impossible.

"Suppress when value is null" hide the dimension if the value is null,

"Suppress Zero-value" hide the Whole dimension only if all the expressions return 0.

in your case the space for the columns is fixed,so if an expression returns 0 the column is invisible but can't be suppressed

DC

[#9]

Hi Nag,

Just modify the chart by increasing the cluster distance.

[nagarajupinnibo]

Hi Shyamal,

I already done it.. I didn't get the solution for it. Iam getting space between two dimensional bars..

But,I need to remove space for each dimension..

You can see it in my example, there is a space between 1 and 3 values of Y for dimension a.

Thanks

-Nag