Showing posts with label lables. Show all posts
Showing posts with label lables. Show all posts

Friday, March 23, 2012

Point Lables for the Bar chart

Hi friends,

We are using SQL Server 2005 Reporting Services for our project.In one of our reports we are showing horizontal bar chart along with the values in front the bar. for eg Graph is Asset Class VS Percentage values. We have Equity , FI , Cash , Others as Asset Class along with percentage values. In graph we are displaying Equity first. When we excecute report I can see the percentage values for FI , cash , others but not for equity.

If I change the order and get equity last then I cant see the value of Others . In short the bar which is coming first is not showing value in front of it. So where I am making mistake ?

can any one help me out ?

regards

sandy.....

As you have already discovered, this is discussed in the following thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=208591&SiteID=1

-- Robert

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