Click on select data in the resulting context menu. And both the horizontal and vertical axis text boxes have been added to the chart then click each of the axis text boxes and enter your own axis labels for x axis and y axis separately. Type your axis label in the box below the menu. Click anywhere in the chart to show the chart tools on the ribbon. Right click on the x axis of the graph you want to change the values of. In the labels section click on axis titles. Add axis label to chart in excel 2013.Ĭlick to select the chart that you want to insert axis label. If you havent yet created the document open excel and click blank workbook then create your graph before continuingstep 2 select the graph. Navigate to the layout tab in microsoft excels toolbar.ĥ in the titles select the x or y axis as desired from the pop down menu. Click primary horizontal axis title or primary vertical axis title. In the expanded menu check axis titles option see screenshot.

If you would like to label the primary horizontal axis primary x axis of the chart click on primary horizontal axis title and then click on the option that you want. Click your graph to select itstep 3 click.

When i build a chart excel for mac seems to default to having the largest scale numbers as the y axis regardless of what column order i build the chart with. I need to swap the x and y axis in order to demonstrate the relationship more clearly. If youre in view mode click edit workbook edit in excel for the web.

Click the type of axis that you want to display or hide. Under the horizontal category axis labels section click on edit. Click on the select range button located right next to the axis label range.ĭouble click an excel document that contains a graph. Display or hide axes click anywhere in the chart for which you want to display or hide axes. On the formatting palette select chart options by clicking on the down arrow. On the design tab click the down arrow next to add chart elements and then hover over axes in the fly out menu.Ĭhange Axis Labels In A Chart In Office Office Support Its to the right of the top right corner of the graph. Make sure youre working in excel for the web edit mode.

How to set x axis in ms excel mac os x