{"id":3748,"date":"2021-05-27T11:01:48","date_gmt":"2021-05-27T03:01:48","guid":{"rendered":"https:\/\/owa.sodexo-cn.com\/blog\/?p=3748"},"modified":"2021-05-27T11:01:48","modified_gmt":"2021-05-27T03:01:48","slug":"how-to-use-icon-to-show-data-characteristics","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=3748","title":{"rendered":"How to use icon to show data characteristics"},"content":{"rendered":"\n

Icon Set is a very useful tool in conditional formatting. With it, you can easily add small icons in cells to highlight data characteristics and make the report more intuitive to the reader.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Example<\/h4>\n\n\n\n

Let us use a common sales data report as an example. Highlight sales growth with colored arrow icons, so reader can immediately find the row of data they care about:
The green arrows represent good sales growth.
The yellow arrows represent medium sales growth.
The red arrows represent bad sales growth.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Steps<\/h4>\n\n\n\n

We don’t need to manually calculate sale growth and add the arrow icons, we just need to setup Icon Set, and Excel will take care of the rest for us.<\/p>\n\n\n\n

1\u3001Create the first column<\/h5>\n\n\n\n

Let us insert a new column named Legend before the \u201cstatistics year\u201d column. Then quote the “Sales Growth Rate” column.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
2\u3001Setup in Conditional formatting<\/h5>\n\n\n\n

First, in Excel sheet, select all the cells that determine the growth. Click \u201cConditional Formatting\u201d and select \u201cIcon Sets\u201d then click \u201cMore Rules\u201d.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
3\u3001Setup Rules<\/h5>\n\n\n\n

Select the icon style, then setup the rules. In which range which icon should be displayed.
As we just display icon in first column, so check the\u201cShow Icon Only\u201d.
After finish setup rules, click \u201cOK\u201dto see the effect.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
At the Last<\/h5>\n\n\n\n

Please note that, the Icon Sets only can setup 5 icons, but it is generally enough.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

If you’re interested in making your report stand out from the crowd, just try it!<\/p>\n","protected":false},"excerpt":{"rendered":"

Icon Set is a very useful tool in conditional formattin … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3748","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"views":1585,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3748","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3748"}],"version-history":[{"count":2,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3748\/revisions"}],"predecessor-version":[{"id":3750,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3748\/revisions\/3750"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3748"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}