I have a bar type chart and i have to display percentage format on the y axis. If i set the appearence of the y axis to percentage it is multiplying the values by 100 more and displaying the Percentage Format. This is happening in both autoscale set to true or false. Could You please suggest how can i get the actual values on y -axis for percent rather than the values which are increased by 100.
In the screenshot attched you see that the values for the chart are between 0 - 100 and if the format is specified default or number or currrency the scale is set to 0-120. But if i change it to percentage it is showing values ranging from 0-12000%. Instead i want 0 - 120 scale with % sign next to it.
In the screenshot attched you see that the values for the chart are between 0 - 100 and if the format is specified default or number or currrency the scale is set to 0-120. But if i change it to percentage it is showing values ranging from 0-12000%. Instead i want 0 - 120 scale with % sign next to it.