{"id":190543,"date":"2023-02-21T17:53:00","date_gmt":"2023-02-21T17:53:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=190543"},"modified":"2023-11-09T13:30:27","modified_gmt":"2023-11-09T13:30:27","slug":"camembert-excel-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/camembert-excel-tout-savoir","title":{"rendered":"Camembert sur Excel : Focus sur ce type de graphique"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"190543\" class=\"elementor elementor-190543\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-966f1d5 e-flex e-con-boxed e-con\" data-id=\"966f1d5\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2e590c3 elementor-widget elementor-widget-heading\" data-id=\"2e590c3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Les s\u00e9ries de donn\u00e9es r\u00e9parties sur plusieurs lignes manquent souvent de lisibilit\u00e9. Pour faciliter l\u2019interpr\u00e9tation des informations pr\u00e9sentes sur un tableau Excel, mieux vaut cr\u00e9er des graphiques.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-53a2f8d elementor-widget elementor-widget-text-editor\" data-id=\"53a2f8d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">Avec <\/span><b>Microsoft<\/b><span style=\"font-weight: 400;\">, vous pouvez pr\u00e9senter les donn\u00e9es sous diff\u00e9rentes formes : nuages de points, histogrammes, barres empil\u00e9es, et bien s\u00fbr les <\/span><b>diagrammes circulaires<\/b><span style=\"font-weight: 400;\">. Dans cet article, nous nous int\u00e9ressons sp\u00e9cifiquement \u00e0 ce dernier.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-313d06e e-flex e-con-boxed e-con\" data-id=\"313d06e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ba35281 elementor-widget elementor-widget-heading\" data-id=\"ba35281\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Pourquoi faire un graphique en secteur ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bd149bd elementor-widget elementor-widget-text-editor\" data-id=\"bd149bd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Les graphiques en secteur sont principalement utilis\u00e9s pour<\/span><b> afficher la r\u00e9partition de diff\u00e9rents jeux de donn\u00e9es.\u00a0<\/b><\/p><p><span style=\"font-weight: 400;\">Par exemple, pour une entreprise vendant des smartphones, il peut \u00eatre int\u00e9ressant de savoir quel mod\u00e8le g\u00e9n\u00e8re le plus de ventes (et inversement). Le <a href=\"https:\/\/datascientest.com\/pie-charts-tout-savoir\">camembert<\/a> <\/span><span style=\"font-weight: 400;\">sur Excel permet alors de visualiser rapidement la part des ventes iPhone, Samsung, Huawei, etc.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Ce diagramme circulaire est <\/span><b>utile pour les ventes<\/b><span style=\"font-weight: 400;\">, mais aussi pour tous les autres pans de l\u2019activit\u00e9 d\u2019une organisation (la r\u00e9partition hommes-femmes, la part des seniors, la part des fournisseurs fran\u00e7ais et\/ou europ\u00e9en, le profil des clients\u2026).\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-086a689 elementor-widget elementor-widget-image\" data-id=\"086a689\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"673\" height=\"350\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/camembert-excel.jpg\" class=\"attachment-full size-full wp-image-190561\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/camembert-excel.jpg 673w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/camembert-excel-300x156.jpg 300w\" sizes=\"(max-width: 673px) 100vw, 673px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-89d2c16 e-flex e-con-boxed e-con\" data-id=\"89d2c16\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d590f8b elementor-widget elementor-widget-heading\" data-id=\"d590f8b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment faire un camembert sur Excel ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-75f97d6 elementor-widget elementor-widget-heading\" data-id=\"75f97d6\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Le diagramme circulaire simple<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8224979 elementor-widget elementor-widget-text-editor\" data-id=\"8224979\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Pour r\u00e9aliser un camembert sur Excel, il suffit de suivre les \u00e9tapes ci-dessous :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez les donn\u00e9es sur votre feuille de calcul (qu\u2019elles soient r\u00e9parties en ligne ou en colonne) ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Insertion\u00a0\u00bb ;\u00a0<\/span><\/li><\/ul><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Ins\u00e9rer un graphique en secteur ou en anneau\u00a0\u00bb.\u00a0<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dc7610e elementor-widget elementor-widget-text-editor\" data-id=\"dc7610e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Vous pouvez ensuite choisir le type de graphique camembert qui vous convient (3D, 2D, anneau ou autres).\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">\u00c0 partir de l\u00e0, vous pouvez <\/span><b>personnaliser votre graphique<\/b><span style=\"font-weight: 400;\"> sur Excel. En effet, \u00e0 c\u00f4t\u00e9 du graphique, plusieurs ic\u00f4nes sont disponibles avec des fonctionnalit\u00e9s diff\u00e9rentes :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><b>\u00c9l\u00e9ment de donn\u00e9es<\/b><span style=\"font-weight: 400;\"> (bouton Plus) : il s\u2019agit de mettre en forme votre camembert. Par exemple, en ajoutant le titre du graphique.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Propri\u00e9t\u00e9 de la s\u00e9rie<\/b><span style=\"font-weight: 400;\"> (bouton Pinceau) : cette ic\u00f4ne vous permet de modifier l\u2019apparence du diagramme, que ce soit au niveau du style, des couleurs de chaque portion, de l\u2019affichage des donn\u00e9es chiffr\u00e9es, etc.<\/span><\/li><li aria-level=\"1\"><b>Filtre<\/b><span> : vous pouvez afficher ou filtrer certaines donn\u00e9es qui ne sont pas pertinentes pour votre analyse.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-91369a5 elementor-widget elementor-widget-text-editor\" data-id=\"91369a5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Gr\u00e2ce aux diff\u00e9rents param\u00e8tres de personnalisation, le camembert sur Excel est un <\/span><a href=\"https:\/\/datascientest.com\/quest-ce-la-dataviz-le-point-avec-nos-data-experts\">outil de visualisation<\/a><span style=\"font-weight: 400;\"> incontournable qui vous permet de mettre en avant les donn\u00e9es principales lors d\u2019un reporting.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\"><strong>Bon \u00e0 savoir :<\/strong> les donn\u00e9es s\u00e9lectionn\u00e9es doivent aboutir \u00e0 un r\u00e9sultat global de 100 %. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d414598 elementor-widget elementor-widget-heading\" data-id=\"d414598\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Les options du camembert<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-932ab1a elementor-widget elementor-widget-text-editor\" data-id=\"932ab1a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Si le camembert sur Excel est tr\u00e8s simple \u00e0 utiliser, de nombreux <a href=\"https:\/\/datascientest.com\/formation-data-analyst\">analystes<\/a><\/span><span style=\"font-weight: 400;\">\u00a0souhaitent <\/span><b>personnaliser leur diagramme<\/b><span style=\"font-weight: 400;\"> pour le rendre plus explicite. Heureusement, Microsoft Excel vous propose de nombreux outils graphiques pour r\u00e9aliser tous types de camembert.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-623b84a elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"623b84a\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-excel\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Apprendre \u00e0 utiliser Excel<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-15ba9b7 elementor-widget elementor-widget-heading\" data-id=\"15ba9b7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Comment afficher les pourcentages sur un graphique camembert ?<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d7e400c elementor-widget elementor-widget-text-editor\" data-id=\"d7e400c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Les donn\u00e9es du camembert sur Excel sont g\u00e9n\u00e9ralement des<\/span><b> donn\u00e9es brutes.<\/b><span style=\"font-weight: 400;\"> Pour reprendre l\u2019exemple des ventes de smartphone, le camembert indique que l\u2019entreprise a vendu 1000 iPhones, 500 Samsung, 500 Huawei\u2026<\/span><\/p><p><span style=\"font-weight: 400;\">Mais si vous le souhaitez, il est aussi possible de <\/span><b>transformer ces informations en pourcentage<\/b><span style=\"font-weight: 400;\">. Pour cela, il vous suffit de cliquer sur \u00ab\u00a0Propri\u00e9t\u00e9 de la s\u00e9rie\u00a0\u00bb et de s\u00e9lectionner #PERCENT dans l\u2019onglet \u00ab\u00a0<\/span><i><span style=\"font-weight: 400;\">Texte de l\u00e9gende personnalis\u00e9\u00a0\u00bb<\/span><\/i><span style=\"font-weight: 400;\">. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fc6c605 elementor-widget elementor-widget-heading\" data-id=\"fc6c605\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Comment faire un demi-camembert ?<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bad6e4c elementor-widget elementor-widget-text-editor\" data-id=\"bad6e4c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Ce type de graphique est particuli\u00e8rement <\/span><b>utilis\u00e9 lors des \u00e9lections<\/b><span style=\"font-weight: 400;\"> pour repr\u00e9senter les diff\u00e9rents partis politiques. Si vous souhaitez obtenir ce type de <\/span><b>r\u00e9sultat visuel,<\/b><span style=\"font-weight: 400;\"> il vous suffit de vous rendre sur le bouton \u00ab\u00a0Propri\u00e9t\u00e9 de la s\u00e9rie\u00a0\u00bb, et de suivre les \u00e9tapes suivantes :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans votre tableau de donn\u00e9e, ins\u00e9rez une ligne \u00ab\u00a0<\/span><i><span style=\"font-weight: 400;\">Montant Total<\/span><\/i><span style=\"font-weight: 400;\">\u00a0\u00bb ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cr\u00e9ez votre graphique et cliquez sur \u00ab\u00a0<\/span><i><span style=\"font-weight: 400;\">Formater la s\u00e9rie de donn\u00e9es<\/span><\/i><span style=\"font-weight: 400;\">\u00a0\u00bb ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Allez dans l\u2019onglet \u00ab\u00a0<\/span><i><span style=\"font-weight: 400;\">graphique<\/span><\/i><span style=\"font-weight: 400;\">\u00a0\u00bb ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Modifiez l\u2019angle de la premi\u00e8re tranche \u00e0 270\u00ba ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Revenez sur le graphique et cliquez sur \u00ab\u00a0<\/span><i><span style=\"font-weight: 400;\">Montant Total<\/span><\/i><span style=\"font-weight: 400;\">\u00a0\u00bb dans la l\u00e9gende ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans le volet \u00ab\u00a0<\/span><i><span style=\"font-weight: 400;\">Format du point de donn\u00e9es\u00a0\u00bb<\/span><\/i><span style=\"font-weight: 400;\">, cliquez sur \u00ab\u00a0Aucun remplissage\u00a0\u00bb ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Supprimez le Total de la l\u00e9gende.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9f6b26f elementor-widget elementor-widget-heading\" data-id=\"9f6b26f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Comment mettre en avant certaines donn\u00e9es ?<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7f5b0d8 elementor-widget elementor-widget-text-editor\" data-id=\"7f5b0d8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Si vous souhaitez mettre en avant un jeu de donn\u00e9es sp\u00e9cifiques, c\u2019est possible avec le camembert sur Excel. Par exemple, les entreprises souhaitant conna\u00eetre la part des salari\u00e9s seniors peuvent r\u00e9aliser un graphique en section mentionnant l\u2019\u00e2ge des salari\u00e9s (- de 25 ans, entre 25 et 35 ans\u2026 plus de 55 ans).\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Bien souvent, les seniors ne repr\u00e9sentent pas la cat\u00e9gorie la plus importante au sein des organisations. Alors pour les rendre plus visibles, vous pouvez mettre en avant le pourcentage sur votre diagramme circulaire. Pour cela, il suffit de <\/span><b>glisser cette cat\u00e9gorie vers l\u2019ext\u00e9rieur. <\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3e6b762 elementor-widget elementor-widget-image\" data-id=\"3e6b762\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"640\" height=\"384\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/camembert-excel1.jpg\" class=\"attachment-full size-full wp-image-190562\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/camembert-excel1.jpg 640w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/camembert-excel1-300x180.jpg 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c304b8a elementor-widget elementor-widget-heading\" data-id=\"c304b8a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Comment ajouter des \u00e9tiquettes de donn\u00e9es ?<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7f49b92 elementor-widget elementor-widget-text-editor\" data-id=\"7f49b92\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Les \u00e9tiquettes de donn\u00e9es mettent en avant certaines informations pour faciliter la lisibilit\u00e9 de votre camembert sur Excel.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Voici les \u00e9tapes \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur le bouton \u00c9l\u00e9ment de donn\u00e9es ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cochez \u00ab\u00a0<\/span><i><span style=\"font-weight: 400;\">\u00e9tiquettes de donn\u00e9es<\/span><\/i><span style=\"font-weight: 400;\">\u00a0\u00bb ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez l\u2019emplacement. <\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4b4732c elementor-widget elementor-widget-heading\" data-id=\"4b4732c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Optimisation de votre graphique<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-590e382 elementor-widget elementor-widget-text-editor\" data-id=\"590e382\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Voici quelques conseils suppl\u00e9mentaires pour optimiser votre diagramme circulaire :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Une seule s\u00e9rie de donn\u00e9es :<\/b><span style=\"font-weight: 400;\"> par exemple, si vous souhaitez faire appara\u00eetre la r\u00e9partition des diff\u00e9rents produits composant votre chiffre d\u2019affaires et les marques pour chaque produit, vous devrez r\u00e9aliser plusieurs camemberts sur Excel.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Aucune valeur nulle ou n\u00e9gative<\/b><span style=\"font-weight: 400;\"> : ces derni\u00e8res n&rsquo;appara\u00eetront pas sur votre graphique. <\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Un maximum de 7 cat\u00e9gories : <\/b><span>au-del\u00e0, le graphique risque de devenir illisible. Or, le camembert sert justement \u00e0 simplifier la visualisation des donn\u00e9es.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-64993d4 e-flex e-con-boxed e-con\" data-id=\"64993d4\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-bb7c224 elementor-widget elementor-widget-heading\" data-id=\"bb7c224\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Ce qu\u2019il faut retenir<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c3ea4f1 elementor-widget elementor-widget-text-editor\" data-id=\"c3ea4f1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Gr\u00e2ce aux feuilles de calculs Excel, il est possible de r\u00e9aliser tous types de graphiques. Et notamment, le diagramme circulaire. Ce dernier est particuli\u00e8rement utile pour afficher la r\u00e9partition des donn\u00e9es. Selon vos besoins, vous pouvez personnaliser votre camembert sur Excel afin de mettre en avant les informations les plus importantes. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e0e2018 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"e0e2018\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-excel\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9marrer une formation Excel<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1081944 e-flex e-con-boxed e-con\" data-id=\"1081944\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a2a6cd4 elementor-widget elementor-widget-html\" data-id=\"a2a6cd4\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Pourquoi faire un graphique en secteur ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Les graphiques en secteur sont principalement utilis\u00e9s pour afficher la r\u00e9partition de diff\u00e9rents jeux de donn\u00e9es.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment afficher les pourcentages sur un graphique camembert ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Les donn\u00e9es du camembert sur Excel sont g\u00e9n\u00e9ralement des donn\u00e9es brutes. Pour reprendre l\u2019exemple des ventes de smartphone, le camembert indique que l\u2019entreprise a vendu 1000 iPhones, 500 Samsung, 500 Huawei, \u2026. Mais si vous le souhaitez, il est aussi possible de transformer ces informations en pourcentage. Pour cela, il vous suffit de cliquer sur \u201cPropri\u00e9t\u00e9 de la s\u00e9rie\u201d et de s\u00e9lectionner #PERCENT dans l\u2019onglet \u201cTexte de l\u00e9gende personnalis\u00e9\u201d.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment mettre en avant certaines donn\u00e9es ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Si vous souhaitez mettre en avant un jeu de donn\u00e9es sp\u00e9cifiques, c\u2019est possible avec le camembert sur Excel. Par exemple, les entreprises souhaitant conna\u00eetre la part des salari\u00e9s seniors peuvent r\u00e9aliser un graphique en section mentionnant l\u2019\u00e2ge des salari\u00e9s (- de 25 ans, entre 25 et 35 ans, \u2026plus de 55 ans).\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Les s\u00e9ries de donn\u00e9es r\u00e9parties sur plusieurs lignes manquent souvent de lisibilit\u00e9. Pour faciliter l\u2019interpr\u00e9tation des informations pr\u00e9sentes sur un tableau Excel, mieux vaut cr\u00e9er des graphiques. Avec Microsoft, vous pouvez pr\u00e9senter les donn\u00e9es sous diff\u00e9rentes formes : nuages de points, histogrammes, barres empil\u00e9es, et bien s\u00fbr les diagrammes circulaires. Dans cet article, nous nous [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":190544,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Camembert sur Excel : Focus sur ce type de graphique<\/title>\n<meta name=\"description\" content=\"Avec Microsoft, vous pouvez pr\u00e9senter les donn\u00e9es sous diff\u00e9rentes formes : nuages de points, histogrammes, barres empil\u00e9es, et bien s\u00fbr les diagrammes circulaires. Dans cet article, nous nous int\u00e9ressons sp\u00e9cifiquement \u00e0 ce dernier.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/camembert-excel-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Camembert sur Excel : Focus sur ce type de graphique\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/camembert-excel-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-21T17:53:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:30:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/camembert-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/camembert-excel-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/camembert-excel-tout-savoir\",\"name\":\"Camembert sur Excel : Focus sur ce type de graphique\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-02-21T17:53:00+00:00\",\"dateModified\":\"2023-11-09T13:30:27+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Avec Microsoft, vous pouvez pr\u00e9senter les donn\u00e9es sous diff\u00e9rentes formes : nuages de points, histogrammes, barres empil\u00e9es, et bien s\u00fbr les diagrammes circulaires. Dans cet article, nous nous int\u00e9ressons sp\u00e9cifiquement \u00e0 ce dernier.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/camembert-excel-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Camembert sur Excel : Focus sur ce type de graphique","description":"Avec Microsoft, vous pouvez pr\u00e9senter les donn\u00e9es sous diff\u00e9rentes formes : nuages de points, histogrammes, barres empil\u00e9es, et bien s\u00fbr les diagrammes circulaires. Dans cet article, nous nous int\u00e9ressons sp\u00e9cifiquement \u00e0 ce dernier.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/camembert-excel-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"Camembert sur Excel : Focus sur ce type de graphique","og_url":"https:\/\/datascientest.com\/camembert-excel-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-02-21T17:53:00+00:00","article_modified_time":"2023-11-09T13:30:27+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/camembert-excel.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/camembert-excel-tout-savoir","url":"https:\/\/datascientest.com\/camembert-excel-tout-savoir","name":"Camembert sur Excel : Focus sur ce type de graphique","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-02-21T17:53:00+00:00","dateModified":"2023-11-09T13:30:27+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Avec Microsoft, vous pouvez pr\u00e9senter les donn\u00e9es sous diff\u00e9rentes formes : nuages de points, histogrammes, barres empil\u00e9es, et bien s\u00fbr les diagrammes circulaires. Dans cet article, nous nous int\u00e9ressons sp\u00e9cifiquement \u00e0 ce dernier.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/camembert-excel-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/190543"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=190543"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/190543\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/190544"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=190543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=190543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=190543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}