Ask Your Question

Show bars side by side

asked 2019-11-27 08:43:17 +0100

Der Alte Fritz gravatar image

updated 2019-11-27 12:09:22 +0100

I am making a graph with columns side by side but the tick box on the data ranges sub-menu called "Show bars side by side" has disappeared. Where is it? Or how do I shows a graph with two sets of columns side by side without using it.

C:\fakepath\Graph with 2 columns.ods

edit retag flag offensive close merge delete


Can you upload a file with the type of graph you are making, and which displays the issue? Preferably the file where you are having issues, but if that is confidential, a file with dummy content should do nicely.

To upload a file, edit your question (no, don'tAdd answer! Use the Edit link below your question) and click the paperclip tool icon above the edit pane.

If we have to guess at what specific settings are in effect for your graph, either because you have set them specifically for this graph or because of install defaults or your adjusted default settings, there is a good chance that our guesses will be wrong. Keep us efficient. Don't make us guess.

keme gravatar imagekeme ( 2019-11-27 10:10:56 +0100 )edit

Seems you are using / used to OpenOffice (Icon on your image) and this is, with respect to LibreOffice, a bit an apple-to-oranges comparison.

Opaque gravatar imageOpaque ( 2019-11-27 12:38:11 +0100 )edit


I am using Version: (x64) LibreOffice Build ID: 23edc44b61b830b7d749943e020e96f5a7df63bf Calc

I cannot show you what I am talking about because it is not there and I cannot make it work, so I have just lifted some pictures from the internet to try and show you what I am talking about. It is not a real screenshot.

I used to be able to make 2 column graphs using this technique in LibreOffice but it no longer works.

I am not using OpenOffice.

Der Alte Fritz gravatar imageDer Alte Fritz ( 2019-11-27 13:58:44 +0100 )edit

Your picture Untitled picture3.png definitely shows an OpenOffice seagull logo at the left upper corner, and only after my comment you added any information about your LibreOffice version. So your astonished "What????" with three additional superfluous question marks is not appropriate.

Opaque gravatar imageOpaque ( 2019-11-27 22:12:56 +0100 )edit

I apologise if you are offended, it was un-intentional.

I was just trying to demonstrate my confusion with your comment about OpenOffice and it looked as if you were answering the question with regard to OO. Especially as the answer did notwork for me. No check box appeared. It took a second comment to resolve the issue.

This is why I was confused as to whether we were talking OO or LO, hence my coment.

Thank you for solution it worked in the end and I appreciate all the hard work done by the volunteers on this site.

Der Alte Fritz gravatar imageDer Alte Fritz ( 2019-11-27 22:43:07 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-11-27 12:53:34 +0100

Opaque gravatar image

updated 2019-11-27 13:06:56 +0100


perform the following

  • Double click on one of your yellow data series data points (all values should be selected)
  • Right click -> Format data series -> Tab: Options
  • Set radio button Align data series to to [o] Secondary Y Axis
  • Tick Settings option [x] Show bars side by side

image description

Finally you may want to disable the automatic scaling of the Secondary Y Axis and set your your own Maximum.

Result could look like this (changed Secondary Y Axis Max to 180):

image description

Tested using LibreOffice

Version:, Build ID: a64200df03143b798afd1ec74a12ab50359878ed
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde5;
Locale: en-US (en_US.UTF-8); UI-Language: en-US, Calc: threaded

Hope that helps.

If the answer is correct or helped you to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more


When I look at this screen I do not see the check box "Show bars side by side". Instead I see a check box called "Connection Lines".

I checked my graph and it is set to "stacked column" but it does not display the necessary check box for me to use the secondary axis.

What you have done is exactly how I would have done this action before my problem is that I do not see the necessary check box to perform the action.


Der Alte Fritz gravatar imageDer Alte Fritz ( 2019-11-27 14:08:06 +0100 )edit

I checked my graph and it is set to "stacked column" but it does not display the necessary check box for me to use the secondary axis.

Right click your diagram to change chart type. Change the type from Stacked to Normal. (Click the sample chart icons in the top half.)

keme gravatar imagekeme ( 2019-11-27 14:54:53 +0100 )edit

Brilliant! The check box has appeared and I can make the change, thank you very much to everyone who contributed.

Der Alte Fritz gravatar imageDer Alte Fritz ( 2019-11-27 17:11:12 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-11-27 08:43:17 +0100

Seen: 171 times

Last updated: Nov 27 '19