Cluster bar chart

[admin_xlsior]

Hi 

in clustered bar chart, how to make the bar not to far from the Y axis also no need to further right. like this pict :

I want to make smaller of the blank area (which I put yellow). 

Thanks,

[amitchandak]

@admin_xlsior , Not very clear. But not much options around padding

[admin_xlsior]

Hi @amitchandak 

Yeah, I too tihinking about Padding, but no luck. Basically there is a lot of empty spaces, and since that chart having negative and positif value, it looks like having a lot of waste spaces. 

If you noticed, the square lines around it is the visual border. right. If at least the one on the right can be more smaller padding, it will be great. At first I thought it is because the Data labels is displayed and put as Outside, but when I turn it off, still the spaces on the right not became smaller. I was thinking of setting the Start and End in the X-axis but it's mean I put some hardcode value limit which will come into trouble if my value is exceeding the End limit.

Another thing is I cannot find gridline for Y-axis. X-axis have it, so I think it looks better if there is grid lines in the background.

Thanks.