erhunters.blogg.se - Change excel graph axis label

You can see that the resultant value axis label shown highlighted in orange within Figure 6 is now set to Currency.įigure 6: Value axis label changed to Currency You can also choose the Currency symbol you need as shown highlighted in green within Figure 6, and set the required number of decimal spaces. Thereafter, select Currency within the Category list shown highlighted in blue within Figure 6. To do so, select the Number option in the Format Axis Task Pane as shown highlighted in red within Figure 6, below. You can also change the value axis label to show as Currency.Notice that the vertical axis label now shows the changed display units as shown highlighted in blue within Figure 5.įigure 5: Value axis label reflecting the changed display units Now, look at Figure 5, below where we have changed the Display units to Hundreds as shown highlighted in red.Also note within Figure 4 that the Auto option next to the Maximum value has now changed to Reset (compare Figures 3 and 4).įigure 4: Value axis label reflecting the changed Maximum value Compare this to the original chart shown in Figure 1, previously on this page. You can see a live preview of the vertical axis label automatically reflecting this change, showing the Maximum value as 10 shown highlighted in blue within Figure 4. Look at Figure 4, below where we have set the Maximum value to 10 as shown highlighted in red.To change any of these values, type the required value within the box provided with each of these options. If you change the Maximum or Minimum value, or change the Major or Minor unit, you will see the vertical axis labels reflecting changes you made.

We know so because the text Auto appears next to these options.

In Figure 3 above, you can see that all vertical axis' Minimum, Maximum, Major, and Minor options are set to default values.

Make sure that the Axis Options button is selected as shown highlighted in red within Figure 3.

This step opens the Format Axis Task Pane, as shown in Figure 3, below.

Make sure you then deselect everything in the chart, and then carefully right-click on the value axis.įigure 2: Format Axis option selected for the value axis If you do not get the Format Axis option in the contextual menu, you may have right-clicked on another chart element. Within this contextual menu, choose the Format Axis option (refer to Figure 2 again).

Select the value axis of the chart on your slide and carefully right-click to access the contextual menu as shown in Figure 2, below.

Let's start with changing vertical (value) axis labels: Follow these steps to learn how you can change your axis labels in PowerPoint 2013 for Windows. They can also have decimals.īefore you begin, you should have a chart inserted in your PowerPoint slide.

Values are typically shown as numbers or percentage values.