Chart Grouping Label Formatting

Is there a way to adjust the orientation of the grouping labels (x-axis) of a bar chart in a report.So instead of displaying the grouping label text horizontally I want to display the text vertically?Is there any way to access the chart object and code this in the report from properties ->code tab? Any suggestions?

From the "Axis Label Formatting Q&A" section of the following whitepaper: http://msdn.microsoft.com/library/en-us/dnsql90/html/MoreSSRSCharts.asp?frame=true#moressrscharts_topic3

Question (X-axis): How does automatic x-axis label positioning work?

Answer: Currently, built-in Reporting Services charts only allow automatic positioning in order to avoid overlapping the x-axis labels. The label direction (horizontal/vertical) of the axis labels depends on the label string sizes and the available space. X-axis labels are either shown horizontally in one line, horizontally in multiple lines with line breaks, or vertically. Showing x-axis labels at an angle, or explicit manual control over individual x-axis label positions is currently not supported.

Note There are several third-party chart add-ins that enable more control over axis labels. These add-ins can be installed on top of Reporting Services 2005.

Chart formatting and non breaking spaces

Hi all,

I'm having a problem and I cannot seem to find how to fix this anywhere on the web.

I have a stacked bar chart with my data labels showing down the x axis. My client wants me to put a bit of white space between the label and the actual chart. So I tried adding spaces to my data label but of course RS thinks they don't exist since they are not non breaking spaces.

How can I do the following in my chart label

=Fields!Myfield.Value & " "

As you can see I want to add a couple of spaces to my data label. I can't use  , all the ampersands get confused. I tried & char(32) but RS doesn't like char(n). I tried ChrW(160) [I saw this in the web somewhere] but this didn't work either.

Is there anything I can do?

thanks in advance, I'm at my wits end (again)

Annabel

Try Chr(160).|||thanks but this made no difference....We have told the client we can't add spaces between the label and the axis, they are ok with it.

Chart formatting and non breaking spaces

Hi all,

I'm having a problem and I cannot seem to find how to fix this anywhere on the web.

I have a stacked bar chart with my data labels showing down the x axis. My client wants me to put a bit of white space between the label and the actual chart. So I tried adding spaces to my data label but of course RS thinks they don't exist since they are not non breaking spaces.

How can I do the following in my chart label

=Fields!Myfield.Value & " "

As you can see I want to add a couple of spaces to my data label. I can't use  , all the ampersands get confused. I tried & char(32) but RS doesn't like char(n). I tried ChrW(160) [I saw this in the web somewhere] but this didn't work either.

Is there anything I can do?

thanks in advance, I'm at my wits end (again)

Annabel

Try Chr(160).|||thanks but this made no difference....We have told the client we can't add spaces between the label and the axis, they are ok with it.

Chart formatting and non breaking spaces

Hi all,

I'm having a problem and I cannot seem to find how to fix this anywhere on the web.

I have a stacked bar chart with my data labels showing down the x axis. My client wants me to put a bit of white space between the label and the actual chart. So I tried adding spaces to my data label but of course RS thinks they don't exist since they are not non breaking spaces.

How can I do the following in my chart label

=Fields!Myfield.Value & " "

As you can see I want to add a couple of spaces to my data label. I can't use  , all the ampersands get confused. I tried & char(32) but RS doesn't like char(n). I tried ChrW(160) [I saw this in the web somewhere] but this didn't work either.

Is there anything I can do?

thanks in advance, I'm at my wits end (again)

Annabel

Try Chr(160).|||thanks but this made no difference....We have told the client we can't add spaces between the label and the axis, they are ok with it.