{"id":550,"date":"2014-07-25T15:22:33","date_gmt":"2014-07-25T13:22:33","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=550"},"modified":"2022-11-03T15:53:01","modified_gmt":"2022-11-03T14:53:01","slug":"excel-deux-types-dans-un-graphique","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2014\/07\/excel-deux-types-dans-un-graphique\/","title":{"rendered":"Excel &#8211; Deux types dans un graphique"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<p>Vous avez cr\u00e9\u00e9 un tableau Excel avec une colonne contenant des libell\u00e9s (Lettres, SSP, Droit, FBM, HEC&#8230;) et deux colonnes de chiffres (2, pour faire simple dans cet exemple). Vous aimeriez cr\u00e9er un graphique; une s\u00e9rie de chiffres doit \u00eatre repr\u00e9sent\u00e9e sous forme de colonne (Histogramme) et la 2\u00e8me s\u00e9rie de chiffres sous forme de ligne (Courbe)*.<\/p>\n<h4><strong>Solution<\/strong><\/h4>\n<ul>\n<li>S\u00e9lectionnez votre tableau Excel<\/li>\n<li>Dans l&rsquo;onglet <em>Insertion,<\/em> cliquez sur le bouton <em>Graphiques sugg\u00e9r\u00e9s<\/em> &gt; <em>Histogramme group\u00e9<\/em><\/li>\n<li>Dans le graphique, cliquez sur la s\u00e9rie de donn\u00e9es que vous voulez transformer en courbe<\/li>\n<li>Allez dans l&rsquo;onglet <em>Cr\u00e9ation de graphique,<\/em> cliquez sur le bouton <em>Modifier le type de graphique<\/em> &gt; <em>Courbes<\/em><\/li>\n<li>Si les donn\u00e9es repr\u00e9sent\u00e9es par la courbe poss\u00e8dent des valeurs tr\u00e8s diff\u00e9rentes des autres valeurs (plus \u00e9lev\u00e9es ou plus faibles), il serait judicieux d&rsquo;ajouter un 2\u00e8me axe au graphique ceci afin d&rsquo;\u00e9viter que votre courbe soit bizarrement plac\u00e9e sur le graphe (pour plus d&rsquo;info, voir <a href=\"https:\/\/people.unil.ch\/jacquelinefrey\/2014\/05\/excel-graphique-obtenir-un-2eme-axe\/\">l&rsquo;article<\/a> traitant de ce sujet)<\/li>\n<\/ul>\n<p><img alt=\"\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-3002\" src=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2020\/07\/types.png\" alt=\"\" width=\"438\" height=\"252\" srcset=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2020\/07\/types.png 661w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2020\/07\/types-300x173.png 300w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2020\/07\/types-624x360.png 624w\" sizes=\"auto, (max-width: 438px) 100vw, 438px\" \/><\/p>\n<p>* \u00e0 ne pas confondre avec une courbe de tendance qui est tout autre chose&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous avez cr\u00e9\u00e9 un tableau Excel avec une colonne contenant des libell\u00e9s (Lettres, SSP, Droit, FBM, HEC&#8230;) et deux colonnes de chiffres (2, pour faire simple dans&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3806,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-only-content.php","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[4],"tags":[48,37,19],"class_list":{"0":"post-550","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-graphique","9":"tag-mise-en-forme","10":"tag-tableau"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/550","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/comments?post=550"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/550\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3806"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}