Have you ever made an Excel chart where you needed to change the value of the axis? For example you wanted to show a chart that depicts 100% of the people you surveyed, but when you created the chart the axis value was greater than 100%. A greater than 100% would not make any sense.
The procedure is easy but a little tricky to find.
Right-click on the axis you need to edit to get the Format Axis menu shown below. Change the axis value to 100% (or the value you want to display. Notice that it is possible to edit the minimum value, too (although it is often best for that value to begin with 0. When you are finished, save and close the window.
The procedure is easy but a little tricky to find.
Right-click on the axis you need to edit to get the Format Axis menu shown below. Change the axis value to 100% (or the value you want to display. Notice that it is possible to edit the minimum value, too (although it is often best for that value to begin with 0. When you are finished, save and close the window.
No comments :
Post a Comment