Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
5 years ago

Cluster bar chart

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,

Tips and Tricks

2 Replies

    • admin_xlsior's avatar
      admin_xlsior
      Post Prodigy
      5 years ago

      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.