Type your axis label in the box below the menu. On the design tab click the down arrow next to add chart elements and then hover over axes in the fly out menu. Display or hide axes click anywhere in the chart for which you want to display or hide axes. Click chart axis titles.Ĭlick anywhere in the chart to show the chart tools on the ribbon. Its to the right of the top right corner of the graph. Navigate to the layout tab in microsoft excels toolbar. Click primary horizontal axis title or primary vertical axis title. 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. Right click on the x axis of the graph you want to change the values of. Make sure youre working in excel for the web edit mode. If youre in view mode click edit workbook edit in excel for the web.
5 in the titles select the x or y axis as desired from the pop down menu. Click to select the chart that you want to insert axis label.Ĭlick your graph to select itstep 3 click. I need to swap the x and y axis in order to demonstrate the relationship more clearly. Double click an excel document that contains a graph.Ĭlick on select data in the resulting context menu. Click the type of axis that you want to display or hide. If you havent yet created the document open excel and click blank workbook then create your graph before continuingstep 2 select the graph. Under the horizontal category axis labels section click on edit.
Add axis label in excel for mac for mac#
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. In excel 2013 you should do as this.Ĭharts Empirical Reasoning Center Barnard College 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. In the labels section click on axis titles.
0 kommentar(er)
