Hello,
I've got a piechart i'm creating from a a number of values, most of which are "0" obviously a piechart is the best way to present this info but my data labels for the "0"s are all coming up on top of each other in a rather unattractive splodge.
Does anyone know how to present only the data labels with values over 0?
Cheers
G
Hi,
Take a look at this link on how to hide zero's in pie charts
http://peltiertech.com/Excel/NumberFormats.html
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks