{"id":8988,"date":"2020-08-30T02:26:11","date_gmt":"2020-08-30T00:26:11","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=8988"},"modified":"2020-07-24T12:47:43","modified_gmt":"2020-07-24T10:47:43","slug":"creer-un-tableau-de-bord-dynamique-avec-excel-en-quelques-clics-3eme-partie-utiliser-les-formats-conditionnels-sur-un-tableau-croise-dynamique-tcd","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=8988","title":{"rendered":"Cr\u00e9er un tableau de bord dynamique avec Excel en quelques clics &#8211; 3\u00e8me partie : utiliser les formats conditionnels sur un tableau crois\u00e9 dynamique (TCD)"},"content":{"rendered":"<p style=\"text-align: justify;\">La construction du <a href=\"https:\/\/www.auditsi.eu\/?p=8969\">tableau de bord dynamique<\/a> avance. Apr\u00e8s la cr\u00e9ation d&#8217;un <a href=\"https:\/\/www.auditsi.eu\/?p=8971\">connecteur de donn\u00e9es (1\u00e8re partie)<\/a>, un <a href=\"https:\/\/www.auditsi.eu\/?p=8972\">tableau crois\u00e9 dynamique (TCD) li\u00e9 au connecteur de donn\u00e9es a \u00e9t\u00e9 mis au point (2\u00e8me partie)<\/a>, le sujet de cette 3\u00e8me partie est l&#8217;usage de la <a href=\"https:\/\/www.auditsi.eu\/?tag=formats-conditionnels\">mise en forme conditionnelle<\/a> dans un TCD.&nbsp;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=9019\" rel=\"attachment wp-att-9019\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9019\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-achats-non-stock\u00e9s-avec-barres-de-donn\u00e9es.png\" alt=\"Excel - TCD achats non stock\u00e9s avec barres de donn\u00e9es\" width=\"752\" height=\"368\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-achats-non-stock\u00e9s-avec-barres-de-donn\u00e9es.png 752w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-achats-non-stock\u00e9s-avec-barres-de-donn\u00e9es-300x147.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-achats-non-stock\u00e9s-avec-barres-de-donn\u00e9es-730x357.png 730w\" sizes=\"auto, (max-width: 752px) 100vw, 752px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Les formats conditionnels mettent en forme (couleurs, police de caract\u00e8res&#8230; mais aussi graphiques) des donn\u00e9es en fonction de la r\u00e9alisation (ou non) de crit\u00e8res d\u00e9finis par l&#8217;utilisateur.<\/p>\n<p style=\"text-align: justify;\">Par exemple, pour ajouter ajouter des <a href=\"https:\/\/www.auditsi.eu\/?p=8918\">barres de donn\u00e9es<\/a> (repr\u00e9sentation graphique des donn\u00e9es dont la taille varie en fonction de leur valeur num\u00e9rique compar\u00e9e \u00e0 la valeur totale), s\u00e9lectionner la zones du TCD concern\u00e9e (ici, s\u00e9lectionner la page de cellules de B7 \u00e0 E19) :<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=9017\" rel=\"attachment wp-att-9017\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9017\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-achats-non-stock\u00e9s-s\u00e9lection-mise-en-forme-cond..png\" alt=\"Excel - TCD achats non stock\u00e9s (s\u00e9lection mise en forme cond.)\" width=\"774\" height=\"422\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-achats-non-stock\u00e9s-s\u00e9lection-mise-en-forme-cond..png 774w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-achats-non-stock\u00e9s-s\u00e9lection-mise-en-forme-cond.-300x164.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-achats-non-stock\u00e9s-s\u00e9lection-mise-en-forme-cond.-768x419.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-achats-non-stock\u00e9s-s\u00e9lection-mise-en-forme-cond.-730x398.png 730w\" sizes=\"auto, (max-width: 774px) 100vw, 774px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Puis, dans le menu Accueil, choisir Mise en forme conditionnelle, Barres de donn\u00e9es et, par exemple, Remplissage uni bleu :<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=9018\" rel=\"attachment wp-att-9018\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9018\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-Mise-en-forme-conditionnelle-Barres-de-donn\u00e9es.png\" alt=\"Excel - Mise en forme conditionnelle Barres de donn\u00e9es\" width=\"440\" height=\"370\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-Mise-en-forme-conditionnelle-Barres-de-donn\u00e9es.png 440w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-Mise-en-forme-conditionnelle-Barres-de-donn\u00e9es-300x252.png 300w\" sizes=\"auto, (max-width: 440px) 100vw, 440px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Les barres de donn\u00e9es ont \u00e9t\u00e9 abord\u00e9es dans l&#8217;article <a href=\"https:\/\/www.auditsi.eu\/?p=8918\">Elaborer un tableau de bord avec des \u00e9l\u00e9ments visuels percutants \u2013 2\u00e8me partie : les barres de donn\u00e9es<\/a>. Le lecteur int\u00e9ress\u00e9 y trouvera toutes les informations utiles sur leur mise en oeuvre. D&#8217;autres formats conditionnels graphiques sont propos\u00e9s par Excel \u00e0 l&#8217;image des jeux d&#8217;ic\u00f4nes (<a href=\"https:\/\/www.auditsi.eu\/?p=8921\">Elaborer un tableau de bord avec des \u00e9l\u00e9ments visuels percutants \u2013 3\u00e8me partie : les jeux d\u2019ic\u00f4nes<\/a>).<\/p>\n<p>Le classeur Excel du tableau de bord est t\u00e9l\u00e9chargeable en bas de page.<\/p>\n<p style=\"text-align: justify;\">La prochaine partie abordera les graphiques crois\u00e9s dynamiques (autre mani\u00e8re de repr\u00e9senter la tendance suivie par une s\u00e9rie de donn\u00e9es) :<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=9030\" rel=\"attachment wp-att-9030\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9030\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-GCD-carburant-final.png\" alt=\"Excel - GCD carburant final\" width=\"749\" height=\"440\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-GCD-carburant-final.png 749w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-GCD-carburant-final-300x176.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-GCD-carburant-final-730x429.png 730w\" sizes=\"auto, (max-width: 749px) 100vw, 749px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">A suivre\u2026<\/p>\n<p style=\"text-align: justify;\">D\u00e9couvrir <a href=\"https:\/\/www.auditsi.eu\/?cat=2265\">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=8893\">Elaborer un tableau de bord avec des \u00e9l\u00e9ments visuels percutants<\/a> \/ <a href=\"https:\/\/www.auditsi.eu\/?glossary=excel\">Tout savoir sur Excel<\/a> \/ <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=\"Cr%C3%A9er%20un%20tableau%20de%20bord%20dynamique%20avec%20Excel%20en%20quelques%20clics%20-%203%C3%A8me%20partie%20%3A%20utiliser%20les%20formats%20conditionnels%20sur%20un%20tableau%20crois%C3%A9%20dynamique%20%28TCD%29\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>La construction du tableau de bord dynamique avance. Apr\u00e8s la cr\u00e9ation d&#8217;un connecteur de donn\u00e9es (1\u00e8re partie), un tableau crois\u00e9 dynamique (TCD) li\u00e9 au connecteur de donn\u00e9es a \u00e9t\u00e9 mis au point (2\u00e8me partie), le sujet de cette 3\u00e8me partie est l&#8217;usage de la mise en forme conditionnelle dans un TCD.&nbsp; Les formats conditionnels mettent &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=8988\" class=\"more-link\">Continue reading &lsquo;Cr\u00e9er un tableau de bord dynamique avec Excel en quelques clics &#8211; 3\u00e8me partie : utiliser les formats conditionnels sur un tableau crois\u00e9 dynamique (TCD)&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=\"Cr%C3%A9er%20un%20tableau%20de%20bord%20dynamique%20avec%20Excel%20en%20quelques%20clics%20-%203%C3%A8me%20partie%20%3A%20utiliser%20les%20formats%20conditionnels%20sur%20un%20tableau%20crois%C3%A9%20dynamique%20%28TCD%29\";<\/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,1326,2265],"tags":[2254,293,68,375,182],"class_list":["post-8988","post","type-post","status-publish","format-standard","hentry","category-audit-de-donnees","category-excel","category-maitriser-excel","category-tableaux-de-bord-dynamiques","tag-barres-de-donnees","tag-formats-conditionnels","tag-tableau-croise-dynamique","tag-tableau-de-bord","tag-tcd"],"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\/8988","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=8988"}],"version-history":[{"count":6,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8988\/revisions"}],"predecessor-version":[{"id":9062,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8988\/revisions\/9062"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}