{"id":13267,"date":"2019-12-18T15:39:56","date_gmt":"2019-12-18T14:39:56","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=13267"},"modified":"2024-02-06T15:47:58","modified_gmt":"2024-02-06T14:47:58","slug":"include-sparkline-with-pivot-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/include-sparkline-with-pivot-table\/","title":{"rendered":"Include Sparkline with Pivot Table"},"content":{"rendered":"<p>Once you have your <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-pivot-tables\/\" target=\"_blank\">Pivot Table<\/a> ready and setup, you want to add something more graphical beside your data points. We have just the thing for you, you can<strong> include sparkline with <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"pivot tables\" data-wpil-keyword-link=\"linked\">pivot tables<\/a><\/strong>!<\/p>\n<p>Here we have our <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> ready:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Include Sparkline with Pivot Table\"  class=\"alignnone size-full wp-image-13269\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-01.png\" alt=\"Include Sparkline with Pivot Table\" width=\"445\" height=\"393\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-01.png 445w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-01-300x265.png 300w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/p>\n<p>See how you can do this in just a couple of steps.<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/CwpJf99GTkY?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Include-Sparkline-with-Pivot-Table.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Select a spot right beside your Pivot Table. Go to <em><strong>Insert &gt; Sparklines &gt; Line<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Include Sparkline with Pivot Table\"  class=\"alignnone size-full wp-image-13270\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-02.png\" alt=\"Include Sparkline with Pivot Table\" width=\"939\" height=\"605\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-02.png 939w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-02-300x193.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-02-768x495.png 768w\" sizes=\"(max-width: 939px) 100vw, 939px\" \/><\/p>\n<p>We want to create a sparkline based on our first row of data. Select the <strong>sales values of 2013-2015<\/strong>. Then click <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Include Sparkline with Pivot Table\"  class=\"alignnone size-full wp-image-13272\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-03.png\" alt=\"Include Sparkline with Pivot Table\" width=\"856\" height=\"235\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-03.png 856w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-03-300x82.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-03-768x211.png 768w\" sizes=\"(max-width: 856px) 100vw, 856px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong> <\/span>On the lower right corner, drag it all the way down to populate the rest of your table with sparklines.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Include Sparkline with Pivot Table\"  class=\"alignnone size-full wp-image-13273\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-04.png\" alt=\"Include Sparkline with Pivot Table\" width=\"516\" height=\"393\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-04.png 516w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-04-300x228.png 300w\" sizes=\"(max-width: 516px) 100vw, 516px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong> <\/span>We can change the type as well. Go to\u00a0<em><strong>Sparklines Tools &gt; Design &gt;Type &gt; Column<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Include Sparkline with Pivot Table\"  class=\"alignnone size-full wp-image-13274\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-05.png\" alt=\"Include Sparkline with Pivot Table\" width=\"885\" height=\"634\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-05.png 885w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-05-300x215.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-05-768x550.png 768w\" sizes=\"(max-width: 885px) 100vw, 885px\" \/><\/p>\n<p>You now have sparklines for your Pivot Table!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Include Sparkline with Pivot Table\"  class=\"alignnone size-full wp-image-13275\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-06.png\" alt=\"Include Sparkline with Pivot Table\" width=\"562\" height=\"411\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-06.png 562w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/Include-Sparkline-with-Pivot-Table-06-300x219.png 300w\" sizes=\"(max-width: 562px) 100vw, 562px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><b>How to Include Sparkline with Pivot Table<\/b><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><strong>Helpful Resource:<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/530x300-Pivot.jpg?x85520\" alt=\"Excel Pivot Table\" width=\"530\" height=\"300\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Once you have your Pivot Table ready and setup, you want to add something more graphical beside your data points. We have just the thing for you, you can include sparkline with pivot tables! Here we have our Pivot Table ready: See how you can do this in just a couple of steps. \ufeff Download [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17771,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[24,4],"tags":[599,459],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/13267"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=13267"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/13267\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17771"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=13267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=13267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=13267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}