Excel 2010 Just the Steps For Dummies
Book image
Explore Book Buy On Amazon

In Excel 2010, you can instantly apply data visualizations to cells using data bars, color scales, and icon sets that help you understand data variations in your tables. Excel provides several options as thumbnails that you simply click to apply the visualization, but you also can specify your own rules with which to apply the visual formatting. For example, you can change the colors used in a color scale gradient to match other colors used in a particular worksheet.

Follow these steps to add visualizations to your data in Excel 2010:

  1. Select the cells to which you want to apply formatting.

  2. On the Home tab, in the Styles group, click the Conditional Formatting button.

  3. Select from the following options:

    Examples of data visualizations in Excel 2010: data bars, a color scale, and an icon set.
    Examples of data visualizations in Excel 2010: data bars, a color scale, and an icon set.
    • Data Bars: A gradient-style bar helps you see the value of a cell relative to other cells. The length of the data bar represents the value in the cell, so a longer bar represents a higher value and a shorter bar represents a lower value. The data bars have six different color options (in both gradient fill and solid fill) designed to match Excel themes.

    • Color Scales: Designed to visually help you understand your data, color scales compare a range of cells by using two colors representing higher or lower values or three colors representing higher, middle, or lower values. The color scale bars include a variety of color themes, including red, yellow, and green. You can also create your own scheme by choosing More Rules under the Color Scales options.

    • Icon Sets: Icon sets help you classify data into three, four, or five categories with each icon representing a range of values such as higher, middle, and lower. Icon sets include arrows, traffic lights, stars, and flags.

      Select the icon set you want to use to represent your data.
      Select the icon set you want to use to represent your data.

To clear visualization formatting, select the formatted cells and then click the Conditional Formatting button on the Home tab. Point to Clear Rules and then select Clear Rules from Selected Cells.

About This Article

This article is from the book:

About the book author:

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988, that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane's authoring experience includes over 40 books on topics, such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of these titles have been translated into other languages, such as French, Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and their Yorkshire Terrier.

This article can be found in the category: