--- title: How to Use Excel Sparklines description: How to Use Excel Sparklines image: https://www.aabyss.uk/hubfs/Imported_Blog_Media/Sparklines_Image-1.png --- [![Aabyss Logo](https://www.aabyss.uk/hs-fs/hubfs/Untitled%20design-1.png?width=218&height=61&name=Untitled%20design-1.png "Aabyss Logo")](https://www.aabyss.uk/) ### 0151 733 3223 - [**](https://www.facebook.com/aabysstech/) - [**](https://twitter.com/aabysstech) - [**](https://www.linkedin.com/company/aabysstech/) - [**](mailto:hello@aabyss.uk) ![Aabyss Blog Heading Background](https://www.aabyss.uk/hubfs/48.jpg "Aabyss Blog Heading Background") ## News & Opinion #### Gain the edge on the world of business technology and cyber security # How to Use Excel Sparklines Posted by [Andrew Allen](https://www.aabyss.uk/news/author/andrew-allen) | 05-Dec-2016 13:54:08 - [Tweet](https://twitter.com/share) ![](https://www.aabyss.uk/hubfs/Imported_Blog_Media/Sparklines_Image-1.png) Excel Sparklines were introduced in Excel 2010 version. It is small line chart that could be easily embedded with the text and gives a great presentable output for easier depiction when aligned next to the tabular data. They are supported in Excel 2010 and above version only. Although sparkline’s design is not limited to lines they can also be represented as columns or win loss. The below example depicts how sparklines look: ![Sparklines_Image-1.png](https://www.aabyss.uk/hs-fs/hubfs/Imported_Blog_Media/Sparklines_Image-1.png?width=504&name=Sparklines_Image-1.png "Sparklines_Image-1.png") ### **When to Use:** Excel Sparklines can be useful if you have your data in a tabular format. You can place the sparklines next to each row to give a clear graphical presentation of the data selected in that particular row. ### **How to Use:** Below listed steps give a clear understanding on how to use excel sparklines: 1. Click on the cell where you want to insert the “Sparkline(s)”. 2. Go the “Insert” tab on the top ribbon. 3. Select the Type of “Sparkline” (Line, Column, Win/ Loss), in this case we will take “Line Sparkline” as example. ![sparklines_image-2](https://www.aabyss.uk/hs-fs/hubfs/Imported_Blog_Media/Sparklines_Image-2.png?width=722&height=374&name=Sparklines_Image-2.png) Line Type of Sparklines So, this was all about how to use excel sparklines. You can also do formatting, add markers, axis, etc to enhance the sparklines. Below section suggests on type of sparklines and their formatting. ### **Type of Excel Sparklines:** - Line – These sparklines are displayed in the format of simple lines. You could change the style of line, sparkline color and marker color.![sparklines_image-6](https://www.aabyss.uk/hs-fs/hubfs/Imported_Blog_Media/Sparklines_Image-6.png?width=681&height=125&name=Sparklines_Image-6.png) - Column – These sparklines are displayed in the format of bars. If the data is of positive value then the column would be lying on the upper axis. For negative data value the column would be below the axis. Likewise for zero value the column would not be displayed and an empty space would be left at that data point. In these sparklines too, you can change the style of column, sparkline color and marker color. - Win / Loss – These sparklines are displayed in the format of bars like “Column” sparklines although these only represent profit or loss. If the data is showing profit (positive data points) then bars would be above the axis and if the data is showing loss (negative data points) then the bars would be inverted and will be below the axis. If the data is of zero value then the column would not be displayed and an empty space would be left at that data point, as shown in above figure as well. In these sparklines as well, you can change the style of column, sparkline color and marker color. You can change the type of sparklines for the whole group or for single row by un-grouping the sparklines first. Thus each row can have a different type of sparkline. Topics: [Tips & Tricks](https://www.aabyss.uk/news/topic/tips-tricks) #### Written by [Andrew Allen](https://www.aabyss.uk/news/author/andrew-allen) My personal and business life. I am lucky to have supportive friends and family, and although I am competitive, I try to put others first. I am an active Rotarian, helping support local and international charities. As a former member of Mountain Rescue, I enjoy spending time with my family in the mountains. We regularly travel to experience new cultures and cuisine; I’m a bit of a foodie! In my day job as Chief Executive, I am responsible for ensuring we stay true to our purpose and values. In a strategic capacity, I am also responsible for developing relationships with key partners and major accounts. I love working with ambitious, growing companies who want to challenge themselves and the status quo. Technology, when properly leveraged, can help an organisation differentiate and beat their competition. It's a real joy to make a difference. [LinkedIn](https://www.linkedin.com/in/askandrewallen/) [Twitter](https://twitter.com/askandrewallen) ## Leave a Comment ### Recent Posts ### Topics - [Aabyss News (45)](https://www.aabyss.uk/news/topic/aabyss-news) - [AI (3)](https://www.aabyss.uk/news/topic/ai) - [Artificial Intelligence (3)](https://www.aabyss.uk/news/topic/artificial-intelligence) - [Attack (12)](https://www.aabyss.uk/news/topic/attack) - [Backup (4)](https://www.aabyss.uk/news/topic/backup) - [BYOD (1)](https://www.aabyss.uk/news/topic/byod) - [Cloud (12)](https://www.aabyss.uk/news/topic/cloud) - [Connectivity (7)](https://www.aabyss.uk/news/topic/connectivity) - [Customer (2)](https://www.aabyss.uk/news/topic/customer) - [Cyber (18)](https://www.aabyss.uk/news/topic/cyber) - [Cyber Insurance (2)](https://www.aabyss.uk/news/topic/cyber-insurance) - [Cybersecurity (53)](https://www.aabyss.uk/news/topic/cybersecurity) - [Data Management (5)](https://www.aabyss.uk/news/topic/data-management) - [Disaster Recovery (6)](https://www.aabyss.uk/news/topic/disaster-recovery) - [Emerging (3)](https://www.aabyss.uk/news/topic/emerging) - [Hospitality (2)](https://www.aabyss.uk/news/topic/hospitality) - [Insider (2)](https://www.aabyss.uk/news/topic/insider) - [IT News (36)](https://www.aabyss.uk/news/topic/it-news) - [IT Support (24)](https://www.aabyss.uk/news/topic/it-support) - [Managed Service (35)](https://www.aabyss.uk/news/topic/managed-service) - [Management (13)](https://www.aabyss.uk/news/topic/management) - [Outsourced IT (2)](https://www.aabyss.uk/news/topic/outsourced-it) - [Password (7)](https://www.aabyss.uk/news/topic/password) - [Productivity (36)](https://www.aabyss.uk/news/topic/productivity) - [Ransomware (4)](https://www.aabyss.uk/news/topic/ransomware) - [Security (51)](https://www.aabyss.uk/news/topic/security) - [Social Media Threats (2)](https://www.aabyss.uk/news/topic/social-media-threats) - [Strategy (24)](https://www.aabyss.uk/news/topic/strategy) - [Technologies (6)](https://www.aabyss.uk/news/topic/technologies) - [Technology (29)](https://www.aabyss.uk/news/topic/technology) - [Technology Budgeting (1)](https://www.aabyss.uk/news/topic/technology-budgeting) - [Tips & Tricks (16)](https://www.aabyss.uk/news/topic/tips-tricks) - [WiFi (1)](https://www.aabyss.uk/news/topic/wifi) - [Work-from-home (1)](https://www.aabyss.uk/news/topic/work-from-home) [see all](https://www.aabyss.uk/news/use-excel-sparklines#) #### ABOUT AABYSS We are commercially focused technology strategists who help clients outperform their competitors through proven leadership, management and support. We make informed IT decisions to simplify your technology needs and support your growing business. ### Subscribe for Cyber Security Updates #### LIVERPOOL OFFICE 19 Meridian Business Village Hansby Drive Liverpool L24 9LG [///cocktail.audible.bulbs](https://what3words.com/cocktail.audible.bulbs) T: 0151 733 3223 E: [hello@aabyss.uk](mailto:hello@aabyss.uk?subject=Website%20Enquiry) #### SHEFFIELD OFFICE 3 Newton Business Centre Thorncliffe Park Estate  Newton Chambers Road Sheffield S35 2PH [///countries.winded.winter](https://what3words.com/countries.winded.winter) T: 0114 361 0062 E: [hello@aabyss.uk](mailto:hello@aabyss.uk?subject=Website%20Enquiry)   #### COMPANY POLICY [Service Level Standards](https://www.aabyss.uk/service-level) [Cookie Policy](https://www.aabyss.uk/cookie-policy) [Privacy Policy](https://www.aabyss.uk/privacy-policy) [Complaints](https://www.aabyss.uk/complaints-policy) [Modern Slavery](https://www.aabyss.uk/hubfs/Downloads/Modern%20Slavery%20Statement.pdf) [Report Abuse](https://www.aabyss.uk/abuse) Company Registered in England & Wales, Company No. 04726959 - [**](https://www.facebook.com/aabysstech/) - [**](https://twitter.com/aabysstech) - [**](https://www.linkedin.com/company/aabysstech/) ©2025 Aabyss Ltd. ** ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Andrew Allen", "url" : "https://www.aabyss.uk/news/author/andrew-allen" }, "datePublished" : "2016-12-05T13:54:08.000Z", "headline" : "How to Use Excel Sparklines", "image" : [ "https://www.aabyss.uk/hubfs/Imported_Blog_Media/Sparklines_Image-1.png" ], "mainEntityOfPage" : { "@id" : "https://www.aabyss.uk/news/use-excel-sparklines", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.aabyss.uk/hubfs/Untitled%20design-1.png" }, "name" : "Aabyss Ltd" } } ```