Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Communicating Data Visually
Communicating Data Visually
Taking advantage of tables
Understanding Excel’s conditional formatting feature
Using the graphical conditional formats
Using conditional formatting formulas
Reviewing tips for using conditional formatting
Introducing the sparkline graphics feature
Adding sparklines to a worksheet
Customizing sparklines
Making a sparkline display only the most recent data
This chapter explores some versatile formatting features for summarizing, highlighting, and
presenting data. The chapter starts by introducing Excel’s table feature, which you can use to
not only apply colorful formatting to a list of data, but also to fi filter and total the data, among
other benefi ts.
You can apply conditional formatting to a cell so that the cell looks different, depending on its
contents. Conditional formatting is a useful tool for visualizing numeric data. In some cases,
conditional formatting may be a viable alternative to creating a chart.
Finally, you can create sparklines to illustrate data values within a cell. Sparklines appear like mini
charts and offer a surprising amount of formatting fl exibility.
Creating a Table
A table is a rectangular range of structured data. Each row in the table corresponds to a single
entity. For example, a row can contain information about a customer, a bank transaction, an
employee, a product, and so on. Each column contains a specifi c piece of information. For example,
Search JabSto ::

Custom Search