Hi All, I believe another easy one that I am not finding a quick answer to -- am simply trying to suppress zeros in a dynamic pie chart where the data format displays both the number and percentage. I am able to suppress if one or the other, but not finding the right format for both. Any suggestions?
Thanks so much.
Sheryl
You could use a helper column where you test the value for zero and output NA() instead.
See this if you also want to remove the legend entry
http://www.andypope.info/charts/piezeros.htm
Perfect! Thank You!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks