{"id":1654,"date":"2015-09-30T16:52:23","date_gmt":"2015-09-30T14:52:23","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1654"},"modified":"2020-06-09T22:58:33","modified_gmt":"2020-06-09T20:58:33","slug":"excel-sparklines-with-excel-tables","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-sparklines-with-excel-tables\/","title":{"rendered":"Excel Sparklines with Excel Tables"},"content":{"rendered":"<p>Did you know that you can include an <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/charts\/sparklines\/\" target=\"_blank\" rel=\"noopener\">Excel Sparkline<\/a> inside an Excel Table? Well you can!<\/p>\n<p>To create an Excel Table you need to highlight your data and press CTRL+T<\/p>\n<p><span style=\"text-decoration: underline;\"><span style=\"color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-insert-an-excel-table\/\" target=\"_blank\">See Tutorial Here<\/a><\/span><\/span><\/p>\n<p>Once you have your Excel Table you can add your Excel Sparklines inside one Column and use the data in other Columns to create your Sparkline.<\/p>\n<p>&#8216;ave a look at the following tutorial which explains this in a few simple steps&#8230;<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/QK6qe6kgViM?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><\/p>\n<p><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><br \/>\n<span style=\"text-decoration: underline; color: #0000ff;\"><a class=\"IRPP_minimalist icon-download\" style=\"color: #0000ff;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Sparklines-Line-with-High-Low-Markers.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download workbook<\/span><span class=\"postTitle px-3\">Sparklines-Line-with-High-Low-Markers.xlsx<\/span><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/www.mothresource.com\/193-8.html\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-667 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/MOTH-468x90.update.your_.skills.animated.chart_.learn_.online.2.gif\" alt=\"MOTH 468x90.update.your.skills.animated.chart.learn.online.2\" width=\"468\" height=\"90\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Did you know that you can include an Excel Sparkline inside an Excel Table? Well you can! To create an Excel Table you need to highlight your data and press CTRL+T See Tutorial Here Once you have your Excel Table you can add your Excel Sparklines inside one Column and use the data in other [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17643,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Excel Sparklines with Excel Tables","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,32],"tags":[94,105],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1654"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1654"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1654\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17643"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}