Suppose Excel generates a chart with titles, a legend, and axis labels all neatly styled in Gill Sans MT—but you’d prefer Goudy Old Style. You can look all over the charting component of the Excel user interface for a command to change the font, but you will look in vain. The Format tab, under Chart Tools, provides access to a fantastic array of fancy text-formatting options. However, if all you want is a different font, you need to return to the worksheet component of the user interface. Every tool at your disposal for formatting worksheet text is available there for use with chart text. Select the text you want to modify, click Home on the ribbon, and then head for the Font group.

With titles, axis titles, and legend text, you can format entire blocks, individual words, or even individual characters. If you need a subscript in your chart title, for example, select the character that needs to be lowered, click Home on the ribbon, click the dialog box launcher in the Font group (the small rectangle in the lower-right corner and to the right of the word Font), and then, on the Font tab of the Font dialog box, select the Subscript check box.