ssrs 2008 r2: Problem with bar chart label
Why is this happening ? see pic below.
My config:
Chart series labels properties:
-- Position: Left (also I tried: center & auto, I got the same problem)
Chart properties:
-- CustomAttributes:
----- BarLabelStyle: Left
I'm using:
SSRS 2008 R2
MS SQL 2008
Windows Server 2008 R2 SP1
August 23rd, 2012 10:57am
Hi
Tonycompu,
It seems that the values are not fitting in the space provided, can you try reducing the font size one or two points. This should allow the values to fit in the empty space.HTH,
Cheers!!
Ashish
Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.
Free Windows Admin Tool Kit Click here and download it now
August 23rd, 2012 11:17am
Hi ashish,
What I need is that value en middle of the cell, I don't need it in the empty space. It doesn't matter if the value is 0%, 34%, 70% or 100%, I need this value in the middle of the cell in front of bar all the time . is this possible?
thanks for your answer
August 23rd, 2012 11:34am
Hi ,
These are called Data-points in the graphs.What you need is select the Data-point in the design mode ,Press F4 for properties ,Then you can select the properties "Position" or "Rotation" to show the Data Points in the graphs.There are other common properties
as well for Data-points.
Regards
Samay
Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.samay
Free Windows Admin Tool Kit Click here and download it now
August 24th, 2012 3:36am
Hi Tonycompu,
From your description, you want the data labels to be displayed in the middle of the textbox that contains the Data Bar (or Bar chart). In a bar chart, we can change the position of the data label by changing the "BarLabelStyle" of the "CustomAttributes"
property. When we set the "BarLabelStyle" to "Left", it always attempts to replace the labels from the left edge of the bar, however, if a bar is not lengthy enough to contains the label totally, the label will be placed on the right side of the
bar. The similar behavior acts when we set the "BarLabelStyle" to "Center". So, we can only set the position of the labels on the Bar chart level and cannot set it on the textbox level.
To work around the issue, we can insert a rectangle into the textbox, drag a Data Bar and a textbox into the rectangle. Then we can set the textbox to display the label data and place it in the center of the rectangle above the Data Bar. The screenshot below
is for your reference:
Hope this helps.
Regards,
Mike Yin
TechNet Subscriber Support
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback
here.Mike Yin
TechNet Community Support
August 28th, 2012 8:03am