Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check Suppress when value is Null in Dimension tab
Hi Neha,
I already checked it. But, spaces are not removed..
Hi,
Can you upload sample document..
Thanks
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.
Hi,
Might be something like attached.
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
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
Hi Nag,
Just modify the chart by increasing the cluster distance.
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