I've seen several solutions for not graphing zeros, but I'm wanting to go a stop further. Right now, the bar chart does not show the zero values, but it still holds a place for those categories on the X axis.
I'm trying to create a chart where the actual category labels will be ignored/hidden when the value is zero.
Is this possible?
Thank you for your time in advance.
May be a legend as shown on this link?
http://peltiertech.com/Excel/Charts/SqueezeColumns.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