Forum Discussion
Advocate IResizing Bar Width in Clustered Column Chart
You have to make sure under X axis that the Type is "Categorical" and not "Continuous" otherwise it won't let you adjust the category width.
cluster column chart bars is supposed to render categorical data and not contineous data. if you can catogories data and add that category field in column legend well then you can adjust spacing and width.
for example
if you have quarter on x axis and month as column legend then for each quarter you expect 3 bars in clustered column bar with some spacing and then next quarter, however clusted column chart will display 3 bars but white space for 9+1 more bars. as a quarter has only 3 months data and for rest 9 months it render 0 value which looks like white space.
a year data -> 4 quarters -> 12 months(means 12 category)
Work around to fix this -> make new field as 'month category' which includes only respective months for quarter.
a year data -> 4 quarters -> 3 months type( means 3 category)
3 months type would be ->
month 1 ->which represnt first month of a quarter -> Jan, Apr, Jul, Oct
month 2 -> which represnt second month of a quarter -> Feb, May, Aug, Nov
month 3 -> which represnt third month of a quarter -> March, June, Sep, Dec
now keeping this month type field in 'column legend' well will display 3 bars and one white space for each quarter