Hi
Is it possible to only have a data label border when there is data?
I have a dynamic column chart with 2 series, and then a 3rd series as an 'invisible' line chart - so as just to show its data labels a little above the 2nd series.
These data labels I have customised to look at a range of formulas to display % change.
Some data labels are blank however (ie formula result = ""). But they still show the border, which I do not want.
Is there a way around this (I'm guessing vba if anything?)
Any help is most appreciated. Cheers
Bookmarks