{"id":104,"date":"2011-07-26T15:21:14","date_gmt":"2011-07-26T15:21:14","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=104"},"modified":"2023-12-30T23:14:26","modified_gmt":"2023-12-30T23:14:26","slug":"excel-training-using-sparklines-to-display-trends-visually","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/excel-training-using-sparklines-to-display-trends-visually\/","title":{"rendered":"Excel Training: Using Sparklines to display trends visually"},"content":{"rendered":"<p>One of the great new features of Excel that users enjoy employing during our <strong>Microsoft Excel Courses<\/strong> here in <strong>London<\/strong> is the\u00a0Sparklines. These can be thought of as mini-Charts that reside in a cell, and can show a trend visually of a group of values.<\/p>\n<p>In the example shown below there are sales figures from four store locations, London, Manchester, Birmingham and Liverpool. We want to see the trend of these figures visually beside each Department row, rather than create a separate Chart.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/07\/excel-training-sparklines-11.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-107\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/07\/excel-training-sparklines-11.jpg\" alt=\"Excel Training - Sparklines\" width=\"484\" height=\"176\" \/><\/a><\/p>\n<p>Start by selecting the range of cells required for the Sparklines. In the example above, Cells B6:E6.<\/p>\n<p>From the Insert Ribbon select the Sparkline style required e.g. Line<\/p>\n<p>The Create Sparklines dialog appears.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/07\/excel-training-london-4.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-108\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/07\/excel-training-london-4.jpg\" alt=\"Excel Training in London - Sparklines Dialog\" width=\"318\" height=\"192\" \/><\/a><\/p>\n<p>Select the location where the Sparkline should be displayed e.g. F6<\/p>\n<p>Click OK \u2013 The Sparkline will appear in the chosen cell as seen below.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/07\/excel-training-london-1.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-109\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/07\/excel-training-london-1.jpg\" alt=\"Excel 2010 Training - Excel Sparkline View\" width=\"842\" height=\"66\" \/><\/a><\/p>\n<p>With the Sparkline cell selected you will see the Sparkline Ribbon \u2013 Design.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/07\/excel-training-london-2.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-110\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/07\/excel-training-london-2.jpg\" alt=\"Excel London Training Centre - Excel Sparkline Ribbon\" width=\"955\" height=\"136\" \/><\/a><\/p>\n<p>From this Ribbon you can chage the appearance and type of Sparkline e.g. from Line to Column or Win\/loss.<\/p>\n<p>Once the format has been completed you can copy the Sparkline to reflect other values, by copy\/paste or using the AutoFill.<\/p>\n<p><em>Sparklines are not visible in earlier versions of Excel (prior to 2010).<\/em><\/p>\n<p><em>The Sparklines option will not be available if a Workbook is opened in Compatibility Mode.<\/em><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the great new features of Excel that users enjoy employing during our Microsoft Excel Courses here in London is the\u00a0Sparklines. These can be thought of as mini-Charts that reside in a cell, and can show a trend visually of a group of values. In the example shown below there are sales figures from [&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":[220,332,339,377,540,559],"class_list":["post-104","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-excel-training-y","tag-learn-excel","tag-london-excel-training","tag-mm","tag-training-excel","tag-use-excel-sparklines-to-visually-display-trends-and-values"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/104","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=104"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/104\/revisions"}],"predecessor-version":[{"id":6802,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/104\/revisions\/6802"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}