Solved

Getting data Labels Inside Columns on a Column Chart in SSRS

Posted on 2013-05-31
2
4,116 Views
Last Modified: 2013-06-03
Hi can someone tell me how to get the data labels on a chart inside of the columns and vertical?
Please see attached screenshot of the chart at the moment.
graph2013.png
0
Comment
Question by:Ed_Snowden
2 Comments
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 300 total points
ID: 39214170
Use the properties window for this (not the properties dialog). To show the properties window select 'View, Properties window' from the menu. This will show the properties window. Now select the data labels in the design of the chart. The properties window will have the options Position and Rotation. Set position to Bottom and Rotation to -90. Like this:
 labels
0
 

Author Comment

by:Ed_Snowden
ID: 39215684
Great that works really well.
I also added the following expression for position because the labels were displaying badly when the data was below 0.2;
=iif((Sum(Fields!PassRespSLA.Value)/Sum(Fields!RespTotal.Value))<0.2 ,"Top","Bottom")
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now