{"id":8921,"date":"2020-08-03T01:09:44","date_gmt":"2020-08-02T23:09:44","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=8921"},"modified":"2020-08-03T13:14:29","modified_gmt":"2020-08-03T11:14:29","slug":"elaborer-un-tableau-de-bord-avec-des-elements-visuels-percutants-3eme-partie-les-jeux-dicones","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=8921","title":{"rendered":"Elaborer un tableau de bord avec des \u00e9l\u00e9ments visuels percutants \u2013 3\u00e8me partie : les jeux d&#8217;ic\u00f4nes"},"content":{"rendered":"<p style=\"text-align: justify;\">Les jeux d&#8217;ic\u00f4nes permette de repr\u00e9senter visuellement des donn\u00e9es&#8230; sous la forme d&#8217;ic\u00f4nes.<\/p>\n<p style=\"text-align: justify;\">C&#8217;est un des type de formats conditionnels pr\u00e9param\u00e9tr\u00e9s propos\u00e9s par Excel.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8917\" rel=\"attachment wp-att-8917\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8917\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-format-conditionnel-jeux-dic\u00f4nes-final.png\" alt=\"TB format conditionnel jeux d'ic\u00f4nes final\" width=\"295\" height=\"302\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-format-conditionnel-jeux-dic\u00f4nes-final.png 295w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-format-conditionnel-jeux-dic\u00f4nes-final-293x300.png 293w\" sizes=\"auto, (max-width: 295px) 100vw, 295px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Il s&#8217;agira d&#8217;afficher des ic\u00f4nes (ici des fl\u00e8ches) en fonction de la progression du chiffre d&#8217;affaires par rapport \u00e0 l&#8217;ann\u00e9e pr\u00e9c\u00e9dente.<\/p>\n<p style=\"text-align: justify;\">Pour l&#8217;utiliser, se positionner sur la cellule souhait\u00e9e (ici K5), puis dans le menu Accueil choisir l&#8217;option Mise en forme conditionnelle, Jeux d&#8217;ic\u00f4nes et le jeux de cinq fl\u00e8ches color\u00e9es :<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8923\" rel=\"attachment wp-att-8923\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8923\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Menu-format-conditionnel-jeux-dic\u00f4nes.png\" alt=\"Menu format conditionnel jeux d'ic\u00f4nes\" width=\"564\" height=\"684\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Menu-format-conditionnel-jeux-dic\u00f4nes.png 564w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Menu-format-conditionnel-jeux-dic\u00f4nes-247x300.png 247w\" sizes=\"auto, (max-width: 564px) 100vw, 564px\" \/><\/a>Ceci fait, personnaliser le jeu d&#8217;ic\u00f4nes : menu Accueil, Formats conditionnels : \u00e9tendre la zone du format \u00e0 la plage =$K$5:$N$17 :<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8924\" rel=\"attachment wp-att-8924\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8924\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Format-conditionnel-Gestionnaire-des-r\u00e8gles-ic\u00f4nes.png\" alt=\"Format conditionnel - Gestionnaire des r\u00e8gles (ic\u00f4nes)\" width=\"709\" height=\"300\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Format-conditionnel-Gestionnaire-des-r\u00e8gles-ic\u00f4nes.png 709w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Format-conditionnel-Gestionnaire-des-r\u00e8gles-ic\u00f4nes-300x127.png 300w\" sizes=\"auto, (max-width: 709px) 100vw, 709px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Puis double-cliquer sur la ligne intitul\u00e9e Jeu d&#8217;ic\u00f4nes et entrer les r\u00e8gles de mise en forme suivantes :<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8925\" rel=\"attachment wp-att-8925\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8925\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Format-conditionnel-R\u00e8gle-de-mise-en-forme-ic\u00f4nes.png\" alt=\"Format conditionnel - R\u00e8gle de mise en forme (ic\u00f4nes)\" width=\"594\" height=\"511\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Format-conditionnel-R\u00e8gle-de-mise-en-forme-ic\u00f4nes.png 594w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Format-conditionnel-R\u00e8gle-de-mise-en-forme-ic\u00f4nes-300x258.png 300w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Les champs Valeur correspondent aux tranches de % : 0,1 pour 10 %, 0,01 pour 1 %&#8230;<\/p>\n<p style=\"text-align: justify;\">Le bouton Ordre inverse des ic\u00f4nes permet d&#8217;inverser le sens des ic\u00f4nes. De m\u00eame, il est possible de changer de jeu d&#8217;ic\u00f4nes (section Style d&#8217;ic\u00f4ne) ou encore de m\u00e9langer les diff\u00e9rents jeux d&#8217;ic\u00f4nes en s\u00e9lectionnant les ic\u00f4nes souhait\u00e9es dans la section Ic\u00f4ne.<\/p>\n<p style=\"text-align: justify;\">Cocher &#8220;Afficher la barre uniquement&#8221; permet de ne plus afficher les donn\u00e9es chiffr\u00e9es.<\/p>\n<p style=\"text-align: justify;\">R\u00e9sultat apr\u00e8s validation (bouton Ok) :<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8926\" rel=\"attachment wp-att-8926\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8926\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-format-conditionnel-jeux-dic\u00f4nes.png\" alt=\"TB format conditionnel jeux d'ic\u00f4nes\" width=\"612\" height=\"368\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-format-conditionnel-jeux-dic\u00f4nes.png 612w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-format-conditionnel-jeux-dic\u00f4nes-300x180.png 300w\" sizes=\"auto, (max-width: 612px) 100vw, 612px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">A l&#8217;issue de cette \u00e9tape, le tableau de bord est maintenant achev\u00e9 :<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8894\" rel=\"attachment wp-att-8894\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8894\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-final.png\" alt=\"TB final\" width=\"940\" height=\"402\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-final.png 940w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-final-300x128.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-final-768x328.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-final-730x312.png 730w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Apr\u00e8s quelques clics seulement, des \u00e9l\u00e9ments visuels comme des <a href=\"https:\/\/www.auditsi.eu\/?p=8897\">graphiques Sparkline<\/a> et des <a href=\"https:\/\/www.auditsi.eu\/?tag=formats-conditionnels\">formats conditionnels<\/a> ont mis en lumi\u00e8re les tendances significatives ; simple mais efficace.<\/p>\n<p>Il n&#8217;est pas percutant ce tableau de bord ?<\/p>\n<p>Le tableau de bord complet est t\u00e9l\u00e9chargeable ci-apr\u00e8s.<\/p>\n<p>Des questions ? Besoin de pr\u00e9cisions ? N&#8217;h\u00e9sitez pas \u00e0 poster vos commentaires en bas de page.<\/p>\n<p style=\"text-align: justify;\">D\u00e9couvrir <a href=\"https:\/\/www.auditsi.eu\/?cat=2251\">tous les articles de cette s\u00e9rie<\/a>.<\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet : <a href=\"https:\/\/www.auditsi.eu\/?p=8969\">Cr\u00e9er un tableau de bord dynamique avec Excel en quelques clics<\/a> \/&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?glossary=excel\">Tout savoir sur Excel<\/a> \/&nbsp;<a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"https:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a>&nbsp;\/ En savoir plus sur l\u2019<a href=\"https:\/\/www.auditsi.eu\/?tag=analyse-de-donnees\">analyse de donn\u00e9es<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Elaborer%20un%20tableau%20de%20bord%20avec%20des%20%C3%A9l%C3%A9ments%20visuels%20percutants%20%E2%80%93%203%C3%A8me%20partie%20%3A%20les%20jeux%20d%27ic%C3%B4nes\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Les jeux d&#8217;ic\u00f4nes permette de repr\u00e9senter visuellement des donn\u00e9es&#8230; sous la forme d&#8217;ic\u00f4nes. C&#8217;est un des type de formats conditionnels pr\u00e9param\u00e9tr\u00e9s propos\u00e9s par Excel. Il s&#8217;agira d&#8217;afficher des ic\u00f4nes (ici des fl\u00e8ches) en fonction de la progression du chiffre d&#8217;affaires par rapport \u00e0 l&#8217;ann\u00e9e pr\u00e9c\u00e9dente. Pour l&#8217;utiliser, se positionner sur la cellule souhait\u00e9e (ici K5), &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=8921\" class=\"more-link\">Continue reading &lsquo;Elaborer un tableau de bord avec des \u00e9l\u00e9ments visuels percutants \u2013 3\u00e8me partie : les jeux d&#8217;ic\u00f4nes&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Elaborer%20un%20tableau%20de%20bord%20avec%20des%20%C3%A9l%C3%A9ments%20visuels%20percutants%20%E2%80%93%203%C3%A8me%20partie%20%3A%20les%20jeux%20d%27ic%C3%B4nes\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[50,48,2251],"tags":[166,1633,293,2255],"class_list":["post-8921","post","type-post","status-publish","format-standard","hentry","category-audit-de-donnees","category-excel","category-tableaux-de-bord-visuels","tag-analyse-de-donnees","tag-excel","tag-formats-conditionnels","tag-jeux-dicones"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8921"}],"version-history":[{"count":7,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8921\/revisions"}],"predecessor-version":[{"id":9090,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8921\/revisions\/9090"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}