Microsoft Office Tutorials and References
In Depth Information
Format Chart Objects
Working with Charts
Format Data Labels
1 Click the data label that you want
2 Click the Format tab on the
3 Click the Format Selection
The Format Legend dialog box
4 Click the type of formatting that
you want to change.
5 Change the desired settings.
6 Click Close to apply the changes.
Excel applies your changes.
How do I change the font for
my chart text?
The quickest way to change the
font is to select the chart element
that contains text and then
rightclick the element to display the
mini toolbar. From there, you can
change the font, font size, font
color, and font alignment, as well
as apply bold and italics
How do I print my chart?
To print only the chart — not any
worksheet data around it — click the
chart to select it, click the File tab, and
then click Print . The Print dialog box
appears; ensure that the Selected
Chart option is selected, and then
click Print .