Change the display of the vertical axis in excel for mac

#CHANGE THE DISPLAY OF THE VERTICAL AXIS IN EXCEL FOR MAC HOW TO#

Under labels click axis titles point to the axis that you want to add titles to and then click the option that you want. Your chart uses text in the source data for these axis labels.

On the formatting palette select chart options by clicking on the down arrow. To change the text of the category labels on the horizontal axis. In the axis title text box that appears within the chart type the label you want the selected axis to have. Make sure the formatting palette is visible. Select the axis title text type in a new label for the axis and then click the graph. In the titles select the x or y axis as desired. If you want to label the depth series axis the z axis of a chart simply click on depth axis title and then click on the option that you want. You can repeat this process for the other axis title.

In a chart you create in excel for the web axis labels are shown below the horizontal axis and next to the vertical axis.

#CHANGE THE DISPLAY OF THE VERTICAL AXIS IN EXCEL FOR MAC HOW TO#

How to create axis labels in excel 2008 mac steps create your graph. Click the cell that has the label text you want to change. Specify the worksheet range that you want to use as category axis labels. Click primary horizontal axis title or primary vertical axis title.

In the axis label range box do one of the following. This is a quick video response for natasha who commented that she couldnt adjust the x axis labels. Make A Histogram In Excel 2016 For Mac A secondary axis can also be used as part of a combination chart when you have mixed types of data for example price and volume in the same chart. To format the title select the text in the title box and then on the home tab under font select the formatting that you want. Make sure youre working in excel for the web edit mode.

Change the display of the vertical axis in excel for mac