I have a graph which shows the % values , i want Y - axis values to be only until 100%. how do i change that , i am currently having 120 % displayed too...
In a bar chart or line chart, go to the chart properties, Axes tab, select max scale as 100 (or 1 depending on your data). That will display those dimensions where value is greater than 100 but it will not display the values or points).
In a bar chart or line chart, go to the chart properties, Axes tab, select max scale as 100 (or 1 depending on your data). That will display those dimensions where value is greater than 100 but it will not display the values or points).
.png "Miguel_Angel_Baeyens"){kind=avatar}
