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

Watch on YouTube

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