Space between chart Bars

[waqasshah]

Dear All,

I am facing problem when try to format the bar charts. The issue is when my dataset crosses over to next year the distance between December 2016 and January 2017 chart bars increases. I just want the same distance between all months chart bars.

I have also tried the options Bar distance and cluster distance but no luck. Please review the attached screenshot.

Kind Regards

Waqas Shah

[swuehl]

What are the dimensions / expressions you are using?

Maybe two expressions, one for each year?

[satheshreddy]

Hi Shah,

Better to share example file we will find the way easily.

Regards

Sathesh

[waqasshah]

I am using following two dimensions

Dimensions

=Left(CompleteMonthNamesRcvd,3) &'/'& RIGHT(CompleteYearNamesRcvd,2)

=CompleteYearNamesRcvd

Expressions

=NUM(SUM(IF( REF_RCVD_DT >= date(floor(monthstart(addmonths(Today(),-12))), 'YYYY-MM-DD') AND PRD_Rcvd <= date(floor(monthend(addmonths(Today(),-1))), 'YYYY-MM-DD')  AND Product=ProductName AND ProductSite='Frankfurt' , TotalProducts)), '#,###.','.',',')

[waqasshah]

Dear Satesh,

Thanks for your repy but issue how you will extract data ? or you just want to see the formulas in chart properties?

[swuehl]

Maybe just remove the second dimension, I don't think it's needed.

[satheshreddy · Accepted solution]

Hi Shah,

here you can use

=Left(CompleteMonthNamesRcvd,3) &'/'& RIGHT(CompleteYearNamesRcvd,2)

and exp you will get data there you have mentioned second dimension I think you are not showing anything based on second dimension.

Regards

Sathish

[waqasshah]

Hi Satesh,

So what you are suggesting I should not use the second dimension in my chart ?

[swuehl]

Right, the second dimension will create a grouped bar chart, that's why you are seeing two spaces for your expression, one is used the previous year, one is used the following year --> space between bars on year change

[waqasshah]

Thank You