The weighted average maturity, or WAM, of one of these securities is the average number of months until the loans are paid off. A higher WAM means that you can expect to receive payments for a longer period of time than a lower WAM indicates.
No worries. Itâs easy to change it back. To change from the R1C1 cell reference style back to to the A1 style, we will change a setting in the options. Click the âFileâ tab. On the backstage screen, click âOptionsâ in the list of items on the left.On the âExcel Optionsâ dialog box, click âFormulasâ in the list of items on the left.In the âWorking with formulasâ section, select the âR1C1 reference styleâ check box so there is NO check mark in the box. Click âOKâ to accept the change and close the âExcel Optionsâ dialog box.n the backstage screen, click âOptionsâ in the list of items on the left. On the âExcel Optionsâ dialog box, click âFormulasâ in the list of items on the left. In the âWorking with formulasâ section, select the âR1C1 reference styleâ check box so there is NO check mark in the box.
Change the format of text and numbers in labels. To change the format of text in category axis labels: Right-click the category axis labels you want to format, and click Font. On the Font tab, choose the formatting options you want. On the Character Spacing tab, choose the spacing options you want.To change the format of numbers on the value axis: Right-click the value axis labels you want to format. Click Format Axis.In the Format Axis pane, click Number. Tip If you don't see the Number section in the pane, make sure you've selected a value axis (it's usually the vertical axis on the left).ight-click the category axis labels you want to format, and click Font. On the Font tab, choose the formatting options you want. On the Character Spacing tab, choose the spacing options you want. To change the format of numbers on the value axis: Right-click the value axis labels you want to format. Click Format Axis.