Microsoft Office Tutorials and References
In Depth Information
Charts: Translate your data into a meaningful image by creating a chart in Excel
(as shown in Figure 1.4). Excel offers dozens of chart types, layouts, and formats to
help you present your results in the clearest way.
Excel’s data visualization features, such as sparklines and charting, help you make
data more compelling and easier to evaluate.
Specialized Data Formatting: Sometimes it’s more expedient to use cell formatting
to help data have more visual impact rather than creating a separate chart. Excel
offers conditional formatting , a tool that enables it to apply specialized formatting
for selected cells based on the results of the formulas in those cells or the contents
of the cells. For example, if you have a spreadsheet calculating grade averages, you
can set up the cells to be formatted in one color for a passing average and another
for a failing average. The conditional formats include data bars, color scales, icon
scales, and more. Excel 2013 offers a sparklines feature that enables you to create a
small chart within a cell. Refer to Figure 1.4 to see examples under Qtr Chart.