Important: Some of the content in this topic may not be applicable to some languages.
Data bars, color scales, and icon sets are conditional formats that create visual effects in your data. These conditional formats make it easier to compare the values of a range of cells at the same time.
Animals icon set includes such icons as Panda, Elephant, Hippopotamus, Turtle, Butterfly, Dolphin. All icons are available in 256-color and translucent True Color formats. Each icon is available in all standard sizes including 16x16, 24x24, 32x32, 48x48 and 256x256 pixels.
Data bars Color scales Icon sets Icon Software
Newer versionsOffice 2011
Format cells by using data bars
Data bars can help you spot larger and smaller numbers, such as top-selling and bottom-selling toys in a holiday sales report. A longer bar represents a larger value, and a shorter bar represents a smaller value.
Format cells by using color scales
Color scales can help you understand data distribution and variation, such as investment returns over time. Cells are shaded with gradations of two or three colors that correspond to minimum, midpoint, and maximum thresholds.
Format cells by using icon sets
Use an icon set to present data in three to five categories that are distinguished by a threshold value. Each icon represents a range of values and each cell is annotated with the icon that represents that range. For example, a three-icon set uses one icon to highlight all values that are greater than or equal to 67 percent, another icon for values that are less than 67 percent and greater than or equal to 33 percent, and another icon for values that are less than 33 percent.
Format cells by using data bars
Data bars can help you spot larger and smaller numbers, such as top-selling and bottom-selling toys in a holiday sales report. A longer bar represents a larger value, and a shorter bar represents a smaller value.
Format cells by using color scales
Color scales can help you understand data distribution and variation, such as investment returns over time. Cells are shaded with gradations of two or three colors that correspond to minimum, midpoint, and maximum thresholds.
![]()
Free Icon Program DownloadFormat cells by using icon setsElephant Over Gray Color Icon Program For Mac
Use an icon set to present data in three to five categories that are distinguished by a threshold value. Each icon represents a range of values and each cell is annotated with the icon that represents that range. For example, a three-icon set uses one icon to highlight all values that are greater than or equal to 67 percent, another icon for values that are less than 67 percent and greater than or equal to 33 percent, and another icon for values that are less than 33 percent.
Icon Program DownloadSee AlsoComments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |