Formatting the Text of Chart Titles, Labels, and Legends
You can change the size and appearance of chart and axis titles, axis labels, data point
labels, and legends.
To format the text of labels and legends:
Depending on which text you want to format, select the appropriate item:
To format all chart titles and labels (excluding the chart legend), click the chart to
change all the text to your font and color choices.
To format the text for all data points in one series only, select the text box for one data
point in the series.
To format the text in an axis label, select the text.
To format the text for all series labels, select the series label box.
To change the text in a chart legend, select the legend.
Use the format bar controls to format the selected text.