Diagonal x-axis labels - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Diagonal x-axis labels

Author

Topic

erica686
Starting Member

13 Posts

Posted - 2009-12-01 : 23:08:07

Hi,

I have created a chart, and would like the labels on the x-axis to appear diagonally, so that they fit.
I am using Visual Studio 2005, and cannot find where I can alter the angle of x-axis labels.

Thanks

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-12-02 : 08:26:15

OK,

Right Click Chart, select Properties
Go to Data Tab
Click [Value] under Values section (may have another name) and click Edit to the right
Click tab "Point Labels" and check the box "Show Point Labels"
The angle slider now should be un-greyed out.

John
It's a small world (but I wouldn't want to paint it)

erica686
Starting Member

13 Posts

Posted - 2009-12-02 : 18:26:50

This will change the angle of the labels in the chart, but I am looking to change the angle of the labels along the x-axis.

Any idea if this is possible?

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-12-03 : 16:47:18

I just went through all and couldn't find the equivilent on the X axis. Thats not to say not possible but have exhausted my experiences. Sorry.

John
It's a small world (but I wouldn't want to paint it)

behrman
Yak Posting Veteran

76 Posts

Posted - 2009-12-07 : 00:09:02

Use the X Axis tab of the Chart Properties dialog box to define the appearance of the x-axis of the chart.

RAQ Report: Web-based Excel-like Java reporting tool

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-12-07 : 08:26:43

behrman, But where on the tab should it be modified?

John
It's a small world (but I wouldn't want to paint it)

Tahumars
Starting Member

15 Posts

Posted - 2009-12-16 : 17:25:16

As far as I know, this can't be done, and believe me I've tried. I have a semi-workaround that makes the x axis labels appear vertically (not diagonally, but it's a lot better than the horizontal way that SSRS shows them by default). Go to the Chart Properties, under the Data tab edit the Category Group. From that dialog box, look at the Label field. Edit that to something along the lines of

=Fields!YourField.Value+"                                               "

That will make them show vertically.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources