How can I increase or decrease the distance between columns?

If you want to keep the size of the chart as a whole, you cannot simultaneously increase or decrease the distances and keep the bar width constant because these variables are interdependent.

To increase the distance between columns with stable column width, the chart must be wider.   To achieve this, you can simply proceed in two steps:

1. Drag the chart wider. Hereby, columns and distances between columns will get wider.

mceclip4.png

2. You can then reduce the width back to approximately the original width under Properties. As a result, you have reached a greater distance between the columns (with stable width).

mceclip5.png

If you only want to increase a spacing between two columns, you can do so by inserting a blank column in your linked Excel spreadsheet.

mceclip6.png

This results in a greater distance between two bars.

mceclip8.png

Was this article helpful?

/

Comments

0 comments

Article is closed for comments.