{"id":8997,"date":"2020-08-23T02:27:09","date_gmt":"2020-08-23T00:27:09","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=8997"},"modified":"2020-07-24T12:45:18","modified_gmt":"2020-07-24T10:45:18","slug":"creer-un-tableau-de-bord-dynamique-avec-excel-en-quelques-clics-2eme-partie-bis-creer-un-tableau-croise-dynamique-tcd-connecte-a-une-source-de-donnees-quelques-astuces","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=8997","title":{"rendered":"Cr\u00e9er un tableau de bord dynamique avec Excel en quelques clics &#8211; 2\u00e8me partie bis : cr\u00e9er un tableau crois\u00e9 dynamique (TCD) connect\u00e9 \u00e0 une source de donn\u00e9es &#8211; Quelques astuces"},"content":{"rendered":"<p style=\"text-align: justify;\">Pour parfaire le <a href=\"https:\/\/www.auditsi.eu\/?p=8972\">TCD \u00e9labor\u00e9 ci-avant<\/a>, voici quelques astuces :<\/p>\n<p style=\"text-align: justify;\">1. Pour \u00e9viter que la largeur des colonnes des TCD ne soit affect\u00e9e lors des mises \u00e0 jour ult\u00e9rieures : cliquer sur le TCD, puis dans le menu Analyse, cliquer sur Options \/ Options :<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8994\" rel=\"attachment wp-att-8994\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8994\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-options.png\" alt=\"Excel - TCD Menu Analyse options\" width=\"1018\" height=\"172\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-options.png 1018w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-options-300x51.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-options-768x130.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-options-730x123.png 730w\" sizes=\"auto, (max-width: 1018px) 100vw, 1018px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Dans la fen\u00eatre d&#8217;options du TCD, d\u00e9cocher la case &#8220;Ajuster automatiquement la largeur des colonnes lors de la mise \u00e0 jour&#8221; :<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8995\" rel=\"attachment wp-att-8995\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8995\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-options-du-TCD.png\" alt=\"Excel - TCD Menu Analyse options du TCD\" width=\"560\" height=\"481\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-options-du-TCD.png 560w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-options-du-TCD-300x258.png 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">2. Le champ Solde (solde comptable) est pr\u00e9sent\u00e9 en K\u20ac pour faciliter la lecture des donn\u00e9es (pour formater l\u2019<strong>affichage des donn\u00e9es en K\u20ac ou M\u20ac<\/strong> sans modifier les donn\u00e9es source, <a href=\"https:\/\/www.auditsi.eu\/?p=7998\">cliquer ici<\/a>).<\/p>\n<p style=\"text-align: justify;\">3. Le TCD d\u00e9compose les dates en ann\u00e9es, mois et trimestres. Excel effectue un <strong>groupement automatique sur les champs date<\/strong>. C&#8217;est le cas ici pour le champ de donn\u00e9es DateCl\u00f4t (date de cl\u00f4ture comptable) :<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8991\" rel=\"attachment wp-att-8991\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8991\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-champ-date-group\u00e9.png\" alt=\"Excel - TCD champ date group\u00e9\" width=\"324\" height=\"615\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-champ-date-group\u00e9.png 324w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-champ-date-group\u00e9-158x300.png 158w\" sizes=\"auto, (max-width: 324px) 100vw, 324px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">C&#8217;est tr\u00e8s pratique dans certains cas. Mais, dans le cas pr\u00e9sent, c&#8217;est la date de cl\u00f4ture qui doit appara\u00eetre (31\/12\/&#8230;). Pour ce faire, cliquer sur une des zones dates du TCD, puis dans le menu Analyse, cliquer sur l&#8217;option Dissocier.<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8992\" rel=\"attachment wp-att-8992\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8992\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse.png\" alt=\"Excel - TCD Menu Analyse\" width=\"1064\" height=\"333\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse.png 1064w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-300x94.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-1024x320.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-768x240.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-730x228.png 730w\" sizes=\"auto, (max-width: 1064px) 100vw, 1064px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">La date appara\u00eet maintenant sous le format jj\/mm\/aaaa :<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8993\" rel=\"attachment wp-att-8993\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8993\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-date-dissoci\u00e9e.png\" alt=\"Excel - TCD Menu Analyse date dissoci\u00e9e\" width=\"1064\" height=\"335\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-date-dissoci\u00e9e.png 1064w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-date-dissoci\u00e9e-300x94.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-date-dissoci\u00e9e-1024x322.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-date-dissoci\u00e9e-768x242.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/Excel-TCD-Menu-Analyse-date-dissoci\u00e9e-730x230.png 730w\" sizes=\"auto, (max-width: 1064px) 100vw, 1064px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/?p=8972\">Retourner vers la 2\u00e8me partie<\/a><\/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\/?cat=2251\">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-%202%C3%A8me%20partie%20bis%20%3A%20cr%C3%A9er%20un%20tableau%20crois%C3%A9%20dynamique%20%28TCD%29%20connect%C3%A9%20%C3%A0%20une%20source%20de%20donn%C3%A9es%20-%20Quelques%20astuces\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Pour parfaire le TCD \u00e9labor\u00e9 ci-avant, voici quelques astuces : 1. Pour \u00e9viter que la largeur des colonnes des TCD ne soit affect\u00e9e lors des mises \u00e0 jour ult\u00e9rieures : cliquer sur le TCD, puis dans le menu Analyse, cliquer sur Options \/ Options : Dans la fen\u00eatre d&#8217;options du TCD, d\u00e9cocher la case &#8220;Ajuster &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=8997\" class=\"more-link\">Continue reading &lsquo;Cr\u00e9er un tableau de bord dynamique avec Excel en quelques clics &#8211; 2\u00e8me partie bis : cr\u00e9er un tableau crois\u00e9 dynamique (TCD) connect\u00e9 \u00e0 une source de donn\u00e9es &#8211; Quelques astuces&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-%202%C3%A8me%20partie%20bis%20%3A%20cr%C3%A9er%20un%20tableau%20crois%C3%A9%20dynamique%20%28TCD%29%20connect%C3%A9%20%C3%A0%20une%20source%20de%20donn%C3%A9es%20-%20Quelques%20astuces\";<\/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":[2270,166,1541,2272,1633,2271,2000,2269,2001,68,182],"class_list":["post-8997","post","type-post","status-publish","format-standard","hentry","category-audit-de-donnees","category-excel","category-maitriser-excel","category-tableaux-de-bord-dynamiques","tag-ajustement-automatique","tag-analyse-de-donnees","tag-date","tag-dissocier","tag-excel","tag-groupement-automatique","tag-ke","tag-menu-analyse-tcd","tag-me","tag-tableau-croise-dynamique","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\/8997","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=8997"}],"version-history":[{"count":5,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8997\/revisions"}],"predecessor-version":[{"id":9060,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8997\/revisions\/9060"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8997"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8997"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8997"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}