When i try to use
for Percentage as 0.0%;'';0.0% for for Y Axis Label, it display as 0.0% for 0 to -0.4 interval.
I am using Percentage as Y-axis Label. Min Range= -1, Max Range= 1, Interval = 0.1
To display 10.0% with interval to 10, I have to set the value as 0.1,0.2,0.3,,,,,,1.0.
As per 0.0%;'';0.0% ,
Last format condition is for 0. It consider -0.1,-0.2,-0.3,-0.4 as 0 and -0.5 and onwards it consider 1 (Becuase it assumes Round(0.1)=0 , Round(0.5)=1).
Why don't you use Auto for interval? I tried your scenario with Auto and it appears correctly. You can still add in this specialized formatting with Auto Interval. See below:
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?