Ask Your Question
1

Hide zero values in the data labels of a chart?

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

RagusLive 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 close merge delete

1 Answer

Sort by » oldest newest most voted
2

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

Comments

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

RagusLive gravatar imageRagusLive ( 2018-06-20 20:44:02 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 264 times

Last updated: Jun 20 '18