Fri 13 Apr 2007, 09:40Delegate Ibrahim said...
Ibrahim has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Chart,label
Is there a way to automatically hide labels on bar charts where there is no data or a value of nil for a given category/column?
Wed 18 Apr 2007, 14:22Trainer David said...
RE: chart,label
Ibrahim
the only way i can think of is to draw a text box on the label you wish to hide, take off the lines and make it the same fill colour as the chart plot area.
hope this helps you
regards
david
