Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
946 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 Reply

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...