{"id":427,"date":"2014-08-04T16:55:38","date_gmt":"2014-08-04T14:55:38","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=427"},"modified":"2022-11-03T15:52:01","modified_gmt":"2022-11-03T14:52:01","slug":"excel-creer-un-graphique-sparkline","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2014\/08\/excel-creer-un-graphique-sparkline\/","title":{"rendered":"Excel &#8211; Cr\u00e9er des graphiques Sparkline"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<p>Vous avez saisi des donn\u00e9es (par ex. nombre de participants de diverses formations sur plusieurs ann\u00e9es) et souhaiteriez obtenir une repr\u00e9sentation visuelle de vos donn\u00e9es.<\/p>\n<h4><strong>Solution : Les<\/strong> <strong>graphiques Sparkline<\/strong><\/h4>\n<ul>\n<li>Cliquez sur la cellule vide situ\u00e9e juste apr\u00e8s votre derni\u00e8re s\u00e9rie de donn\u00e9es (dans mon exemple G2)<\/li>\n<li>Allez dans l&rsquo;onglet Graphiques &gt; groupe Ins\u00e9rer des graphiques sparkline &gt; cliquez sur le bouton Ligne<\/li>\n<li>S\u00e9lectionnez la 1\u00e8re s\u00e9rie de valeurs pour d\u00e9finir la plage de donn\u00e9es \u00e0 utiliser pour cr\u00e9er le graphique (dans mon exemple de B2 \u00e0 F2)<\/li>\n<li>Une fois le 1er graphique cr\u00e9\u00e9, utilisez la petite poign\u00e9e de recopie bleue (en G2) pour recopier le graphique vers le bas (sur G3 et G4)<\/li>\n<li>Augmentez la hauteur des lignes 2-3-4 pour donner un peu d&rsquo;espace aux graphiques<\/li>\n<li>Utilisez l&rsquo;onglet contextuel Graphiques sparkline pour \u00e9diter ou effacer les graphiques<\/li>\n<\/ul>\n<p><a href=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/08\/sparkline.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-564\" src=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/08\/sparkline-1024x294.png\" alt=\"sparkline\" width=\"625\" height=\"179\" srcset=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/08\/sparkline-1024x294.png 1024w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/08\/sparkline-300x86.png 300w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/08\/sparkline-624x179.png 624w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2014\/08\/sparkline.png 1118w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous avez saisi des donn\u00e9es (par ex. nombre de participants de diverses formations sur plusieurs ann\u00e9es) et souhaiteriez obtenir une repr\u00e9sentation visuelle de vos donn\u00e9es. Solution :&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3806,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-cover.php","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[4],"tags":[48],"class_list":{"0":"post-427","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-graphique"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/427","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=427"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/427\/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=427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}