Hiya folks - this will probably be a stupid question, but I have searched and searched and found no answer. I have a chart (column table) containing a series of data that includes only positive numbers, in a range from 0 to the hundreds. I need to make the table automatically hide any columns that are 0, and ONLY show columns if the data is greater than or equal to 1. Is this doable?
Thank you for your time.
Trying uses #N/A. See link for more info
http://peltiertech.com/Excel/Charts/...nalChart1.html
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
EDIT: My coworker thought he had figured it out, but unfortunately not. I tried the above poster's idea, and it DOES make the column disappear, but it does not remove the data label, so the table just has an empty column with a name beneath it. Is there a way to make the data series ignore both the name and value, if the value is zero?
Last edited by Jeremy.Whitney; 12-08-2007 at 09:45 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks