#Format vertical axis excel for mac how to#
#Format vertical axis excel for mac for mac#

Now, let us learn how to change category axis labels. You can similarly change value labels to show percentages, fractions, etc.You can see that the resultant value axis label shown highlighted in blue within Figure 6 is now set to Currency.įigure 6: Value axis label changed to Currency You can choose the Currency symbol you need, and also the decimal spaces. Thereafter, change the Category to Currency as shown highlighted in red within Figure 6. To do so, select the Number option in the sidebar as shown highlighted in green 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.Compare this to the original chart shown in Figure 1, previously on this page.įigure 4: Value axis label reflecting the changed Maximum value The vertical axis label automatically reflects this change, showing the maximum value as 10 shown highlighted in blue in Figure 4. Look at Figure 4, where we have set the Maximum value to 10 shown highlighted in red.If you change the maximum or minimum values or change the major units, you will see the vertical axis labels reflecting the changes you made. We know so because the Auto check-box is selected for all these options. In Figure 3 above, you can see all the vertical axis' Scale options are set to default values.Doing so opens the Format Axis dialog box, as shown in Figure 3, below.

From the contextual menu, choose the Format Axis option (refer to Figure 2 again).įigure 2: Format Axis option selected for the value axis Select the value axis of the chart on your slide and right-click (or Ctrl + click) to access the contextual menu, as shown in Figure 2, below.Let's start with changing vertical (value) axis labels in PowerPoint 2011 for Mac: Changing Value Axis Labels We used a column chart for this example.įollow these steps to learn how you can change your axis labels. Make sure your chart type supports axes.īefore you begin, you should have a chart inserted in your PowerPoint slide. You can also change the chart type from one to another.

#Format vertical axis excel for mac for mac#

Tip: If you don't know how to insert a chart, refer to our Inserting Charts in PowerPoint 2011 for Mac tutorial.