Excel - How To Do A Sparkline (Tiny Charts) In Excel - Episode 2010
3,182 views · Published 5 September 2016 · 5:21 · Indexed 14 November 2026
Channel: MrExcel.com · 2016 · Education
Microsoft Excel Tutorial: How To Do A Sparkline In Excel Welcome to another episode of the MrExcel Podcast, where we dive into all things Excel. In today's episode, we will be discussing a new feature in Excel 2010 called Sparklines. These are data intense word size charts, as defined by Professor Edward Tufte in his book Beautiful Evidence. To learn more about Sparklines and see some examples, be sure to check out his book. In this episode, we will be using Sparklines to add a trendline to our dashboard. We have already used Slicers and a pivot chart, and now it's time to incorporate Sparklines to make our dashboard even more visually appealing and informative. By using Sparklines, we can fit a lot of data into a small space, making it easier to analyze and understand. To add Sparklines to our dashboard, we will first need to create a new Pivot Table from our original data. Then, we will select the data we want to use for the Sparklines and insert them as a column in the Pivot Table. We can then remove the grand totals from the Pivot Table and format the Sparklines to our liking. This includes making the columns wider to make the Sparklines larger, and changing the colors of the high and low points to highlight important trends. One thing to keep in mind when using Sparklines is that they are scaled independently of each other. However, if we want them to be scaled together, we can adjust the axis minimum and maximum settings. This will ensure that the Sparklines are all on the same scale, making it easier to compare and analyze the data. In tomorrow's episode, we will continue to build our dashboard by incorporating Slicers to control the data in our Pivot Table. Be sure to subscribe to our playlist by clicking the "i" in the top right corner to stay updated on all of our Excel tips and tricks. And don't forget to check out our book, which covers everything we discuss in our August and September podcasts. Thanks for tuning in and we'll see you next time for another netcast. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Pivot Sparklines (00:11) Building a Dashboard with Slicers and Pivot Charts (00:21) Using Sparklines to Show Trends by Sales Rep (01:09) Customizing Sparklines for Better Visualization (02:32) Recap and Tips for Using Sparklines (03:54) Integrating Sparklines into a Dashboard (04:21) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #pivottable #excelcharts #sparklines This video answers these common search terms: where are sparklines in excel how to do a sparkline in excel how to show sparkline markers in excel what are spark lines in excel create a sparkline in excel excel how to insert sparklines how do you add line sparklines in excel how to create line sparklines in excel how to add sparklines in excel how to make a small chart in excel Sparklines are a great way to fit a trend into a small space. Episode recap: Sparklines are word-sized charts See the book Beautiful Evidence by Edward Tufte Use Sparklines to fit data in a small space Build a second pivot table from the original data Put the data for the sparklines in the pivot table Remove the grand totals from the pivot table Select the numbers for the sparklines Choose Insert, Sparklines, Column Select where you want the sparklines to go Make the column wider to make the sparklines larger You can also make the row height taller You can even (gasp) merge cells to make the sparklines wider Change the color of the high and low point If you want the sparklines to be scaled together, change the axis minimum and maximum Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153837/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920