Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
944 views
in Technique[技术] by (71.8m points)

graph - Hide zero value data labels for excel charts (with category name)

I'm trying to hide data labels for an excel chart if the value for a category is zero. I already formatted it with a custom data label format with #%;;;

Chart with format code #%;;;

As you can see the data label for C4 and C5 is still visible, but I just need the category name if there is a value.

Do you have any tips?

question from:https://stackoverflow.com/questions/65880979/hide-zero-value-data-labels-for-excel-charts-with-category-name

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

2.1m questions

2.1m answers

60 comments

57.0k users

...