How to Angle Text in Excel 2013 Graph

When creating graphs and charts in Excel 2013, you may need to add degree symbols to your text. This can be especially useful when working with data that requires angles or measurements. Fortunately, there are several ways to add a degree symbol to your text in Excel.

One way to get the degree symbol is by using the CHAR formula. To do this, follow these steps:

1. Copy the degree symbol from another source, such as a web page.

2. Open a new cell in Excel and type the CHAR formula: =CHAR(176).

3. Press Enter to insert the degree symbol.

Alternatively, you can use a keyboard shortcut to insert the degree symbol. To do this, follow these steps:

1. Select the cell where you want to insert the degree symbol.

2. Hold down the ALT key and press 0176 on your numeric keypad.

3. Release the ALT key and the degree symbol will be inserted.

Another way to add a degree symbol is by using VBA code. This method requires some programming knowledge, but it can be useful if you need to automate the process of adding degree symbols to your text.

To use VBA to add a degree symbol to numbers, follow these steps:

1. Open the Visual Basic Editor by pressing ALT + F11 or by navigating to Developer > Visual Basic in the ribbon.

2. In the Visual Basic Editor, insert a new module by clicking Insert > Module.

3. Paste the following code into the module:

```

Sub AddDegreeSymbol()

Dim cell As Range

For Each cell In Selection

cell.Value = Replace(cell.Value, '°', Chr(176))

Next cell

End Sub

```

4. Save the module by clicking File > Save.

Now you can run the macro to add a degree symbol to your text. To do this, follow these steps:

1. Select the cells that contain the numbers you want to format with a degree symbol.

2. Go back to the Visual Basic Editor and click Run > Run Sub/User Form.

3. Click OK to confirm that you want to run the macro.

4. The degree symbol will be added to your selected text.

In conclusion, there are several ways to add a degree symbol to your text in Excel 2013. Whether you choose to use the CHAR formula, a keyboard shortcut, or VBA code, you can easily add this important symbol to your graphs and charts.

How to angle text in excel 2013 graph