We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

[Calc] displaying exact data value on Y-axis of bar graph [closed]

asked 2018-03-07 16:15:49 +0200

bengineer gravatar image

updated 2020-09-23 13:25:16 +0200

Alex Kemp gravatar image


I'm new to LibreOffice and Calc. I have a data range I've plotted in a bar graph (see embedded image below), and I would like to display the exact values of the data on the Y-axis, instead of something "proportional" (for example, one of my values is 24319, and I would prefer that that exact value were shown at left, instead of just a bar near the 25000 major-axis line mark of the Y-axis).

image description

My goal is to display something similar to the chart below. Hopefully this is helpful.

image description

Thanks in advance for your help.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-04-23 03:39:15.358321

1 Answer

Sort by » oldest newest most voted

answered 2018-03-07 16:31:12 +0200

erAck gravatar image

The axis uses intervals, which can't be changed to reflect individual data points. But you can activate Data Labels. Double click the chart, then click on a column (you should see green marker points on each column), then right click to get the context menu and choose Insert Data Labels (or use menu Insert -> Data Labels). You then have the data values displayed as labels on top of each column. If you click on such data label you can apply formatting, context menu Format Data Labels or menu Format -> Format Selection.

edit flag offensive delete link more


erAck, thanks for the help. I've gotten something more like what I'm looking for. Looking through the Data Labels formatting menu, it looks like there is no way to manually position the data labels, except for the options in the Placement drop-down menu (Outside, Center, Near origin, etc.). Do you know of any ways to manually control the position of the Data Labels within the Chart?

bengineer gravatar imagebengineer ( 2018-03-07 16:55:02 +0200 )edit

Question Tools

1 follower


Asked: 2018-03-07 16:15:49 +0200

Seen: 2,458 times

Last updated: Mar 07 '18