Click the chart, and then click the Chart Design tab. This step applies to Word for Mac only: On the View menu, click Print Layout. You can add data labels to show the data point values from the Excel sheet in the chart.

If you would only like to add a title/label for one axis (horizontal or vertical), click the right arrow beside вЂAxis TitlesвЂ™ and select which axis you would like to add a title/label.Line graphs are one of the standard graph options in Excel, along with bar. Then, check the tickbox for вЂAxis TitlesвЂ™. Excel for Office 365 includes several Click on a data label in the chart.First off, you have to click the chart and click the plus (+) icon on the upper-right side. In a chart sheet or an embedded chart , click the value (y) axis that you want to change.1 How to add chart axis tick marks. Color, and style of axis labels, click an axis label, click the Axis Labels tab at the top of the sidebar on the right, then use the controls in the Font section of the sidebar to make. Change the font, style, and size of chart text.

Likewise, when you change the order of the categories from left to right, the value labels will flip from the left side to the right side of the chart. To reverse the order of the values on the selected axis, select the Values in reverse order check box.Note When you change the order of the values on the value (y) axis from bottom to top, the category labels on the category (x) axis will flip from the bottom to the top of the chart. To change the value axis to logarithmic, select the Logarithmic scale check box.Tip This type of scale is useful when the values that are plotted in the chart cover a very large range. For example, you can display chart values ranging from 1,000,000 to 50,000,000 as 1 to 50 on the axis and show a label that indicates that the units are expressed in millions. To change the units displayed on the value axis, select the units that you want in the Display units list.If you want to show a label that describes the units, select the Show display units label on chart check box.Tip If the chart values are large numbers, you can make the axis text shorter and more readable by changing the display unit of the axis. To change the interval of tick marks and chart gridlines , type a different number in the Major unit box or Minor unit box.

Because the scale of the line chart's category axis can't be changed as much as the scale of the value axis that is used in the xy (scatter) chart, you might consider using an xy (scatter) chart instead of a line chart if you need to change the scaling of that axis or display it as a logarithmic scale. This difference is an important factor in deciding which chart type to use. This effectively moves the category labels to the opposite side of the chart.Note This option overrides the Category X crosses at value.Tip XY (scatter) charts show values on both the category (x) axis and the value (y) axis, while line charts show values on only the value (y) axis. To force the x-axis, cross the value axis at the highest value, and select the Category (X) axis crosses at maximum value check box.

Excel For Mac Adding Chart Axis Label