Increase width of bar chart

I would like to change the width of the bar in the chart. I have created a bar chart with 3 series to be shown alongside each other. The width of each bar is a thin line and not a bar. I have tried all options and there does not seem to be a way to do this. Can anyone help please?
image description


  • Enter edit mode (Double click the chart)
  • Select a data series
  • Right click -> Format Data Series -> Tab: Options
  • Set option Spacing to a lower value

image description

Tested using:

Version: / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US, Calc: threaded

Hope that helps.

Thanks for the very good guide. It did not work initially. I had to change the x-axis type to text as my data is weekly and not daily. All good now.

1 Like

Rudster’s solution is best: change the x-axis type to text.

Other workarounds include:

  • deleting the Categories range (but then you’ve got no useful labels),
  • changing the “resolution” of the date scale to month instead of day, and
  • adding wide borders to the data series format.