Chart Labels at an angle?

Hi,

I have created a report with bar chart but the labels are too long and often go into next line. Is there any way to specify text orientation for labels of a bar chart? I would like to show the chart labels at an angle. Is it possible?

Any help will be appreciated!

This depends on which labels you are referring to. If you are referring to data point labels, then yes, it is possible to specifiy an angle. However, if you are referring to the labels on one of the axes, then no, it is not possible at this time to specify an angle. These labels are positioned automatically. The ability to manually set the angle for axis labels is a potential new feature for the next version of Reporting Services.

To Set the Angle for Data Point Labels:
In the Report Designer, there is a section on the Chart Value properties dialog that allows you to specify an angle for data point labels. This is located on the Point Labels tab of this dialog, which can be reached by creating or editing a Chart Value on the Data tab of the Chart properties dialog.

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.