Display % on Y- axis of bar chart in ssrs

Question

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...

Answer 1

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)

Answer 2

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 %.

Answer 3

Hi,

Ok, you can use custom format as below

---

- Chintak (My Blog)

Answer 4

Thanks

Answer 5

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