Today i would like to show you the little trick for your SSRS graphs.
I am displaying values (percentage values) in my bar charts as “Data Labels”. But the “Y” axis of my bar char still displays value without the “%” sign.
What I need:
The bar chart should display the “%” value in Data Labels as well as on my Y axis.
When you format the Data Label to apply “%” sign by making it of type “Percentage” in “Series Label Properties” -> “Number” -> “Percentage”. It actually multiply the value by 100 and put a % sign at the end. Woh … but the value i am displaying on my Data Labels are already percentage. I just need to display the % sign at the end.
Let’s trick the SSRS to display that % sign on you Data Labels as well as on your Y axis.
2. Right click on Data Label -> Series Label Properties -> Number -> Currency -> select 2 check-boxes : “Show symbol after value” and “Include a space”
4. View your chart. Now apply the same for Y axis.
I hope this will help you somewhere.