How To Add Axis Labels In Excel For Mac

4 Add Notes to an Excel Chart When you create a graph in Microsoft Excel 2010, the axis labels and legend titles are drawn from the information in the cells surrounding the data. Adding a Thousand or Million Suffix to Numbers in Excel For huge numbers, it is easier to read $23M or $25K rather than $23,000,000 or $23,000. So let’s see how you can convert a large number in Thousands, Millions or Billions to a easy to read number.

When you create a graph in Microsoft Excel 2010, the axis labels and legend titles are drawn from the information in the cells surrounding the data. However, if you have subscripts or superscripts in the text in those cells, they will not transfer over to the graph, making the text in the graph appear wrong. You can edit the fonts for most of the text on your graph, but if you need to include subscripts in the axis labels or your legend, you'll have to use text boxes over the chart text, as you can't alter only part of these labels.

Right-click in the text box and choose 'Size and Properties' from the pop-up menu. Click the 'Fill' option on the right side of the window that appears, then click the radio button next to 'Solid Fill.' Click on the paint can icon that appears and click the white color from the palate. Drag the slider under transparency all the way to the left.

The click the 'Properties' option on the left side of the window. Click the radio button next to 'Size With Chart.' Click 'Close' to close the window, and you will now just see your new text on the chart.

Excel 2007 doesn't have a dialog box that allows you to edit chart and axis titles — you need to insert them. If the text you want for your axis title is already in your worksheet, you can link to the text rather than retype it. For example, say you have a chart that compares list prices for a number of office properties. Follow these steps to add horizontal and vertical axis titles to the chart by linking to text in the worksheet: • Click on your chart. • Click the Layout tab under Chart Tools. • Click Axis Titles in the Labels group. • Point to Primary Horizontal Axis Title and select Title Below Axis.

• Click in the formula bar and enter = (the equals sign). Free voip software for mac. • Click the cell in your worksheet that contains the label Property and then press [Enter].

• Click Axis Titles in the Labels group. • Point to Primary Vertical Axis Title and select Vertical Title. • Click in the formula bar and enter = (the equals sign).

• Click the cell in your worksheet that contains the label List Price and then press [Enter]. You can now select the axis titles and format them any way you wish. Miss a Word tip?