Data in or at a top of each bar in a graph

[michaldybczak]

I need to display a number correlating to the graph bar’s. It can be at the end (on top) of the bar or inside it, preferably on top, because some bars are too small to contain visible numbers.

All I found was this:

How can i show actual values inside the bar chart elements

Hello, Do not have a method for total on top of a bar. Not certain it is possible. Example: [image description] Select chart with a double left mouse click. Each section of the stack needs to be done separately. Left mouse click on a stack section - in example blue (Amount 1) was selected. Right mouse click and select Insert Data Labels. Do this for each section. In example there are three sections. After inserting, you can again right click & perform other formatting with Format Dat…

However, my chart contains a few dozens (maybe over a hundred) of bars, so going one each at a time is not possible. Additionally, as I said, the difference between the lowest bars (1 to 10) and highest ones (thousands) is too big, so the low ones are almost not visible at a scale, so it’s not possible to add any label inside it.

Since the last topic was almost 6 years ago, I wanted to ask if this was added at some point, or is it still not possible to add such data to the chart?

[LeroyG]

Edit the chart, open the context menu, and choose Insert Data Labels.

After that you can format the data labels.

Or select the serie, chose menu Insert - Data Labels - Data Labels tab.

Version: 24.2.7.2 (X86_64) / LibreOffice Community

[michaldybczak]

Wow! It worked as you described!

Basically, what I did:

• right-click on the graph and chose Edit
• right-click on the random bar and chose Insert Data Labels

That was it. It showed the number on top (in my case on the side, since the graph is horizontal) of the EACH bar. This is exactly what I wanted!