--- description: Chart in Excel will occupy a large area in Excel interface. You can use a tiny chart called sparkline to reflect the tendency of data instead. title: Sparkline - Mini Chart to Show Data Trends in Your Excel Worksheet image: https://www.datanumen.com/blogs/wp-content/uploads/2016/11/1-an-example-for-create-line-sparkline.jpg --- - - - [Home](https://www.datanumen.com/blogs/) > [Solutions](https://www.datanumen.com/blogs/category/solutions/) > [Office Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/) > [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) > Sparkline – Mini Chart to Show Data Trends in Your Excel Worksheet # Sparkline – Mini Chart to Show Data Trends in Your Excel Worksheet [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 Share Now: - - - - - - - - *Chart in Excel will occupy a large area in Excel interface. Hence, you can use a tiny chart called sparkline to reflect the tendency of data instead.* You can create a sparkline in a cell, and this graphic will not take up a large area in the interface. For example, now you need to display the tendency of the sales volume, you can use the sparkline in this worksheet. ![An Example for Create Sparkline](https://www.datanumen.com/blogs/wp-content/uploads/2016/11/1-an-example-for-create-line-sparkline.jpg "An Example for Create Sparkline") ## Add a Sparkline 1. Click a cell where you want to put the sparkline. 2. Next click the tab “Insert” in the ribbon. 3. And then click the button “Line” in the area of “Sparklines” area in the ribbon.![Insert Sparkline](https://www.datanumen.com/blogs/wp-content/uploads/2016/11/2-insert-line-sparkline.jpg "Insert Sparkline") 4. Next you will see the window “Create Sparklines”. Here input the data range into the textbox. You can either input the range manually or use the mouse to select the area.![Data Range](<> "Data Range") 5. After that, click “OK” in the window. Therefore, the sparkline will appear in the cell.![The Line Sparkline](<> "The Line Sparkline") 6. Repeat the above steps and create sparklines for other products.in addition, you can also use the fill handle to add sparklines. ![Line Sparkline for Other Cells](<> "Line Sparkline for Other Cells") ## Modify the Sparkline You will find that the sparkline is a little small. You can also modify them to make it better. 1. Change the cells width and height to make sparklines bigger in those cells.![Bigger Line Sparklines](<> "Bigger Line Sparklines") 2. Select a cell with the line. 3. Click the tab “Design” in the ribbon. 4. And then check the option “Markers” in the toolbar. Thus, the markers will appear in the sparklines. Therefore, you can clearly see the tendency in those lines.![Markers](<> "Markers") 5. If you want to change the style, you can also set in the toolbar. In the style area in the toolbar, you can change the style of the sparklines. Besides, you can also change the color in the two options “Sparkline Color” and “Marker Color”.![Modify Style](<> "Modify Style") Here in the image below, we also show a different style of those lines. ![New Style](<> "New Style") ## Delete Sparkline You cannot delete the sparkline in Excel by pressing the button “Delete” on the keyboard. You need to use the feature in the toolbar in Excel. 1. Click the cell that you need to delete. 2. Next click the button “Design” in the ribbon. 3. And then click the button “Clear”.![Delete Lines](<> "Delete Lines") Thus, the sparkline will be deleted from your worksheet. ## Data Disaster will Compromise Your Excel Files Sometimes you will meet with data disaster. And the result can be disastrous if you cannot handle it correctly. As a result, some of your Excel files will also be damaged. You can prepare an [Excel recovery](https://www.datanumen.com/excel-repair/) tool before you suffer from data disaster. Thus, whenever you find your Excel corrupts, you can fix it immediately. ## Author Introduction: Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including [word recovery](https://www.datanumen.com/word-repair/) and outlook repair software products. For more information visit [www.datanumen.com](https://www.datanumen.com/) Share Now: - - - - - - - - [← Previous post](https://www.datanumen.com/blogs/2-methods-insert-outlook-contact-info-word-document/) [Next post →](https://www.datanumen.com/blogs/quickly-insert-delete-line-breaks-batch-excel-cells/) Comments are closed. ![Data Recovery Blog]() Follow or like us on Facebook, LinkedIn and Twitter to get all promotions, latest news and updates on our products and company. - - - ### Featured Products - [DataNumen Outlook Repair](https://www.datanumen.com/outlook-repair/) - [DataNumen SQL Recovery](https://www.datanumen.com/sql-recovery/) - [DataNumen Exchange Recovery](https://www.datanumen.com/exchange-recovery/) - [DataNumen Access Repair](https://www.datanumen.com/access-repair/) - [DataNumen Excel Repair](https://www.datanumen.com/excel-repair/) - [DataNumen PDF Repair](https://www.datanumen.com/pdf-repair/) - [DataNumen Word Repair](https://www.datanumen.com/word-repair/) - [DataNumen Zip Repair](https://www.datanumen.com/zip-repair/) ### Popular posts ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.datanumen.com\/blogs\/sparkline-mini-chart-show-data-trends-excel-worksheet\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/sparkline-mini-chart-show-data-trends-excel-worksheet\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"Sparkline – Mini Chart to Show Data Trends in Your Excel Worksheet","datePublished":"2016-11-08T04:12:20+00:00","dateModified":"2025-10-03T09:26:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/sparkline-mini-chart-show-data-trends-excel-worksheet\/"},"wordCount":477,"commentCount":0,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/sparkline-mini-chart-show-data-trends-excel-worksheet\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/11\/1-an-example-for-create-line-sparkline.jpg","articleSection":["Excel Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/sparkline-mini-chart-show-data-trends-excel-worksheet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/sparkline-mini-chart-show-data-trends-excel-worksheet\/","url":"https:\/\/www.datanumen.com\/blogs\/sparkline-mini-chart-show-data-trends-excel-worksheet\/","name":"Sparkline - Mini Chart to Show Data Trends in Your Excel Worksheet","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/sparkline-mini-chart-show-data-trends-excel-worksheet\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/sparkline-mini-chart-show-data-trends-excel-worksheet\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/11\/1-an-example-for-create-line-sparkline.jpg","datePublished":"2016-11-08T04:12:20+00:00","dateModified":"2025-10-03T09:26:19+00:00","description":"Chart in Excel will occupy a large area in Excel interface. You can use a tiny chart called sparkline to reflect the tendency of data instead.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/sparkline-mini-chart-show-data-trends-excel-worksheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/sparkline-mini-chart-show-data-trends-excel-worksheet\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/11\/1-an-example-for-create-line-sparkline.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/11\/1-an-example-for-create-line-sparkline.jpg","width":586,"height":101,"caption":"An Example for Create Sparkline"},{"@type":"WebSite","@id":"https:\/\/www.datanumen.com\/blogs\/#website","url":"https:\/\/www.datanumen.com\/blogs\/","name":"Data Recovery Blog","description":"Discuss every aspect of data recovery","publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datanumen.com\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.datanumen.com\/blogs\/#organization","name":"Data Recovery Blog","url":"https:\/\/www.datanumen.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","width":296,"height":397,"caption":"Data Recovery Blog"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataNumen","https:\/\/x.com\/DataNumen","http:\/\/www.linkedin.com\/company\/datanumen","https:\/\/myspace.com\/datanumen\/","http:\/\/www.pinterest.com\/datanumen\/","https:\/\/www.youtube.com\/channel\/UCVIIuuKfUBHSJauUaVP13tw"]},{"@type":"Person","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957","name":"AuthorCCW","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","caption":"AuthorCCW"},"sameAs":["https:\/\/www.datanumen.com\/"]}]} ```