Microsoft Office Tutorials and References
In Depth Information
Adding Great-Looking Graphics
For example, to select the number format with the comma as the
thousands separator and no decimal places, you select Number on the
Category drop-down list box; then leave the Use 1000 Separator (,) check
box selected and enter in the Decimal Places text box. 0
5. To change the alignment and orientation of the labels on the selected
axis, click the Size & Properties button under Axis Options on the
Format Axis task pane. Then, indicate the new orientation by clicking
the desired vertical alignment in the Vertical Alignment drop-down list
box and desired text direction in the Text Direction drop-down list.
6. Click the Close button to close the Format Axis task pane.
As you choose new options for the selected axis, Excel 2013 shows you the
change in the chart. However, these changes are set in the chart only when
you click Close in the Format Axis dialog box.
To change the default font, font size, or other text attributes for entries along
the selected x- or y-axis, click the appropriate command buttons in the Font
group on the Home tab (see Chapter 3 for details).
Adding Great-Looking Graphics
Charts are not the only kind of graphic objects you can add to a worksheet.
Indeed, Excel lets you spruce up a worksheet with a whole bevy of graphics,
including sparklines (new tiny charts that fit right inside worksheet cells),
text boxes, clip art drawings supplied by Microsoft, as well as graphic images
imported from other sources, such as digital photos, scanned images, and
pictures downloaded from the Internet.
In addition to these graphics, Excel 2013 supports the creation of fancy
graphic text called WordArt as well as a whole bevy of organizational and
process diagrams known collectively as SmartArt graphics.
Sparking up the data with sparklines
Excel 2013 supports a special type of information graphic called a sparkline
that represents trends or variations in collected data. Sparklines are tiny
graphs generally about the size of the text that surrounds them. In Excel
2013, sparklines are the height of the worksheet cells whose data they
represent and can be any of the following chart types:
Search JabSto ::




Custom Search