Ask Your Question

Hide zero values in the data labels of a chart? [closed]

asked 2018-06-20 09:50:35 +0200

RagusLive gravatar image

updated 2020-09-23 13:18:03 +0200

Alex Kemp gravatar image

I am using a line graph to display my spending over the course of a month, and I have chosen to display the data labels for added readability; however there are numerous days where my spending was zero and the "$0.00" being displayed at the bottom of the chart is mucking the readability up.
Note; I do still want the data -point- to be there, I just want the -label- to go away for values=0.
Is this possible?

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 2020-07-21 13:45:44.938811

1 Answer

Sort by » oldest newest most voted

answered 2018-06-20 10:38:56 +0200

Regina gravatar image

Go in edit mode of the chart. Open the data label dialog.

image description

Click on button Number format.

image description

Make sure that the option "Source format" is not checked.There is a line for theFormat code. The format code has first a part for positive values, then a part for negative values and third a part for value zero. The delimiter between the parts is a semicolon. Your existing format code has likely only two parts. So add a semicolon to specify the appearance of value zero and then enter "" after it for an empty string. Click on the green Add button and then OK.

edit flag offensive delete link more


This works perfectly! Thank you so much for the illustrated answer!

RagusLive gravatar imageRagusLive ( 2018-06-20 20:44:02 +0200 )edit

Question Tools

1 follower


Asked: 2018-06-20 09:50:35 +0200

Seen: 2,022 times

Last updated: Jun 20 '18