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