Display % on Y- axis of bar chart in ssrs
Hi all, I have designed a bar chart report in SSRS i have some values in percentage on Y- axis it is showing 0 to 100 values with 10 as interval I need to display symbol % behind the labels of Y-axis i,e 10%, 20% ... over Y-axis. Please suggest me a way to achieve this. Thanks in advance...
July 26th, 2012 1:14am

Hi, Not sure whether you have COLUMN Or BAR chart, but as you are saying that you need % symbol on Y axis.. But steps to do it 1. Select axis property 2. Go to number and select percentage. - Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2012 2:04am

Thanks, If we use the above option it is multiplying the values with 100 then placing % behind the values. Can we write an expression to concatenate % to the label values so that we can get values as it is with %.
July 26th, 2012 2:23am

Hi, Ok, you can use custom format as below - Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2012 3:12am

Thanks
July 26th, 2012 3:27am

hi there, Also check out this approach for displaying % sign in your chart. http://www.bigator.com/2012/08/04/ssrs-chart-displaying-sign-on-y-axis-displaying-sign-on-data-labels/ thanks, Khilit http://www.bigator.com
Free Windows Admin Tool Kit Click here and download it now
August 5th, 2012 1:45am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics