The following sections provide guidelines to help you make good use of colors, and to avoid bad use of colors. On the other hand, bad use of color can distract users, and even cause fatigue if over-used. Good use of colors can provide a positive emotional feeling right from the start. Good use of color and icons in your Excel reports improves decision making by helping to focus users' attention on critical information and by helping users visually understand results.
The effective use of color in any document can dramatically improve the document's attractiveness and readability. Top of Page Using color effectively when analyzing dataĪlmost everyone likes colors. You can format cells by using a two-color scale, three-color scale, data bars, and icon sets format cells that contain specific text, number, date or time values, top or bottom ranked values, above or below average, unique, or duplicate values and create many rules and manage rules more easily. For example in the following table of icon sets, 3 Arrows icon set, the green arrow that points upward represents higher values, the yellow sideways arrow represents middle values, and the red arrow that points downward represents lower values. Use an icon set to annotate and classify data into three to five categories that are separated by a threshold value. You can also sort and filter by using an icon set that you created through a conditional format. This picture shows filtering and sorting based on color or icon on the Category, M/M Δ%, and Markup columns. You can sort and filter by format, including cell color and font color, whether you have manually or conditionally formatted the cells. Together, sorting, filtering, and conditionally formatting data can help you and other people who use your spreadsheet make more effective decisions based on your data. You conditionally format data to help you visually explore and analyze data, detect critical issues, and identify patterns and trends. You filter data to display only the rows that meet criteria that you specify and hide rows that you do not want displayed, for one or more columns of data. You sort data to quickly organize your data and to find the data that you want. What is the overall age distribution of employees?
Where are the exceptions in a summary of profits over the past five years? Who are the highest performing and lowest performing students in the freshman class? Which products have greater than 10% revenue increases from year to year? Who has sold more than $50,000 worth of services this month? Sorting and filtering data, along with conditionally formatting data, are integral parts of data analysis and can help you answer questions such as the following: Using color effectively when analyzing data Overview of sorting and filtering data by color and icon set Sorting and filtering data by color is a great way to make data analysis easier and help the users of your worksheet see the highlights and data trends at a quick glance. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More.
0 kommentar(er)
