{"id":1186,"date":"2012-11-12T14:06:28","date_gmt":"2012-11-12T14:06:28","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1186"},"modified":"2023-12-30T23:11:50","modified_gmt":"2023-12-30T23:11:50","slug":"how-to-apply-sparklines-in-excel-2010","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/how-to-apply-sparklines-in-excel-2010\/","title":{"rendered":"How to apply sparklines in Excel 2010"},"content":{"rendered":"<p>Sparklines are small charts that fit into a cell in your Excel workbooks.\u00a0 They act as a great visual summary of trends that use a small amount of space and allow you to make quick and effective comparisons in the blink of an eye.<\/p>\n<figure id=\"attachment_1187\" aria-describedby=\"caption-attachment-1187\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/sparkline-image-excel-vba-training-london.png\"><img decoding=\"async\" class=\"size-medium wp-image-1187\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/sparkline-image-excel-vba-training-london-300x58.png\" alt=\"sparkline image excel vba training london\" width=\"300\" height=\"58\" \/><\/a><figcaption id=\"caption-attachment-1187\" class=\"wp-caption-text\">Sparklines are quick visual representations of your data<\/figcaption><\/figure>\n<p><strong>Features<\/strong><\/p>\n<ul>\n<li>Sparklines will <strong>actively update<\/strong> as you add new data.<\/li>\n<li>Sparklines are printed when you print a worksheet that contains them.<\/li>\n<li>There are <strong>three types of Sparklines<\/strong>: Line, Column, and Win\/Loss.<\/li>\n<li>You can use sparklines to show trends in a series of values, identify minimum and maximum values, business cycles, customer demand over a quarter\u2026and so much more.<\/li>\n<li>They are located in the <strong>Insert tab<\/strong><\/li>\n<li>You can<strong> customise <\/strong>them using the<strong> Design tab<\/strong><\/li>\n<li>You can <strong>copy<\/strong> the format into other cells using the <strong>autofill handle<\/strong><\/li>\n<\/ul>\n<figure id=\"attachment_1189\" aria-describedby=\"caption-attachment-1189\" style=\"width: 182px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/sparklines-excel-vba-training-london.png\"><img decoding=\"async\" class=\"size-full wp-image-1189\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/sparklines-excel-vba-training-london.png\" alt=\"sparklines excel vba training london\" width=\"182\" height=\"123\" \/><\/a><figcaption id=\"caption-attachment-1189\" class=\"wp-caption-text\">Three styles of sparklines to chose from&#8230;<\/figcaption><\/figure>\n<p><strong><br \/>\nHow to add a sparkline<br \/>\n<\/strong><\/p>\n<ol>\n<li>Select the cell or multiple cells where you want to create your Sparkline.\n<p><figure id=\"attachment_1188\" aria-describedby=\"caption-attachment-1188\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/selecting-sparkline-range-excel-vba-training-london.png\"><img decoding=\"async\" class=\"size-medium wp-image-1188\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/selecting-sparkline-range-excel-vba-training-london-300x159.png\" alt=\"selecting sparkline range excel vba training london\" width=\"300\" height=\"159\" \/><\/a><figcaption id=\"caption-attachment-1188\" class=\"wp-caption-text\">Select your range and Excel will prompt your next action.<\/figcaption><\/figure><\/li>\n<li>Go to the Insert tab, and in the Sparklines group, click the type of sparkline that you want to use. Remember, there are three styles to choose from: Line, Column, or Win\/Loss.<\/li>\n<li>Excel will give you a prompt for you to enter a Data Range you are using to create the Sparklines.<\/li>\n<li>Enter your data range, or click and drag to choose your data range. Then add the cell details where you want the sparkline to appear.<\/li>\n<li>Click OK\u00a0.<\/li>\n<li>Excel will then show you the Sparklines in your selected cells.<\/li>\n<li>If you want to copy this sparkline format to other cells, use the \u00a0autofill handle.<\/li>\n<li>Ta da!\n<p><figure id=\"attachment_1190\" aria-describedby=\"caption-attachment-1190\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/sparkline-applied-excel-vba-training-london.png\"><img decoding=\"async\" class=\"size-medium wp-image-1190\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/sparkline-applied-excel-vba-training-london-300x156.png\" alt=\"sparkline applied excel vba training london\" width=\"300\" height=\"156\" \/><\/a><figcaption id=\"caption-attachment-1190\" class=\"wp-caption-text\">Sparklines applied!<\/figcaption><\/figure><\/li>\n<\/ol>\n<p>Sparklines are very simple to apply and can give you a quick snapshot of data &#8211; this can be great if you are asked for a quick update on trends in a meeting. \u00a0You can get more out of Excel including advanced techniques from Microsoftnet Excel VBA training\u00a0<a title=\"Microsoftnet Excel VBA training\" href=\"https:\/\/www.stl-training.co.uk\/vba-training-london.php\">https:\/\/www.stl-training.co.uk\/vba-training-london.php<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sparklines are small charts that fit into a cell in your Excel workbooks.\u00a0 They act as a great visual summary of trends that use a small amount of space and allow you to make quick and effective comparisons in the blink of an eye. Features Sparklines will actively update as you add new data. Sparklines [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[289,375],"class_list":["post-1186","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-how-to-add-a-sparkline-in-excel","tag-microsoftnet-excel-vba-training-london"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1186"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1186\/revisions"}],"predecessor-version":[{"id":6711,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1186\/revisions\/6711"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}