Point Label Properties

I have a stacked barchart with point labels applied. For some time periods
some of the values are zero. When this occurs, the zero lables stack up at
the bottom of the chart and appear very unattractive. Is there a way I can
conditionally format the point labels so that they only show if greater than
zero'Try ### in the format code box (number of #'s = max digits of any value in
you graph)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp
"bugfish69" wrote:
> I have a stacked barchart with point labels applied. For some time periods
> some of the values are zero. When this occurs, the zero lables stack up at
> the bottom of the chart and appear very unattractive. Is there a way I can
> conditionally format the point labels so that they only show if greater than
> zero'|||Thank you. Why is the obvious so hard to see sometimes?
"Marcus K" wrote:
> Try ### in the format code box (number of #'s = max digits of any value in
> you graph)
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp
> "bugfish69" wrote:
> > I have a stacked barchart with point labels applied. For some time periods
> > some of the values are zero. When this occurs, the zero lables stack up at
> > the bottom of the chart and appear very unattractive. Is there a way I can
> > conditionally format the point labels so that they only show if greater than
> > zero'sql