Skip to main content
Skip to main content
Microsoft 365

Sparklines in Excel

Thanks to Sam Radakovitz, a Program Manager on the Excel team, for putting together this series on Sparklines.

For Excel 2010 we’ve implemented sparklines, “intense, simple, word-sized graphics”, as their inventor Edward Tufte describes them in his book Beautiful Evidence.  Sparklines help bring meaning and context to numbers being reported and, unlike a chart, are meant to be embedded into what they are describing:

blogimage1

In the above example, the sales number alone gives you a single moment in time, but adding sparklines in the table, next to the numbers it’s describing, gives history and shows a pattern of sales.  The sparklines aren’t floating on the grid of Excel like a chart does.  They aren’t rows, column, or sheets away from the data.  They are in the table giving context to the numbers, unobtrusively, and appear like text in the cell.

blogimage2

Sparklines in this table are displaying the win / loss record for a softball league … they can convey the entire season of each team in the league.  From reading the sparklines we can tell ‘QPB Ballers’ lost their first game but never lost again, ‘Amazon Bats’ had a rough start but finished strong, and ‘Brusing Borders’ was inconsistent throughout the season.

For this first version of sparklines in Excel we wanted to do a couple of things:

  • Enable folks to easily create the most common types of sparklines found today
  • Create a stable and efficient code base shared with Excel charting that we can build on in future releases

Over the next week or two I’m going to review sparklines in Excel and cover how to create them, style them, adjust options for the axis and group, and give a few other tips and examples of using them in Excel … as well as introduce you to a book store demo file with a variety of different usages for sparklines in Excel:

blogimage3

Stay tuned!

You may also like these articles

Image for: View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365

View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365

This month, we're announcing some top requested features like tracking changes in Excel and live transcriptions in Teams, as well as some soon-to-be-favorites like meeting recaps, turning Word documents in presentations, and more.

Image for: Family hanging out at home baking holiday cookies using Lenovo Ideapad Flex 3 to make holiday cards

New apps and features in Microsoft 365 for individuals and families this fall

Since we introduced Microsoft 365 to individuals and families earlier this year, we have continued to deliver new innovations across our apps and services to help you and your family save time and stay connected. See what’s new below. Locate your loved ones and build better driving habits with Microsoft Family Safety Stay connected even…

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…