Sparkline

Last updated
Example sparklines in small multiple
IndexDayValueChange
Dow Jones Sparkline dowjones new.svg 10765.45−32.82 (−0.30%)
S&P 500 Sparkline sp500.svg 1256.92−8.10 (−0.64%)
Sparklines showing the movement of the Dow Jones Industrial Average and S&P 500 during February 7, 2006

A sparkline is a very small line chart, typically drawn without axes or coordinates. It presents the general shape of a variation (typically over time) in some measurement, such as temperature or stock market price, in a simple and highly condensed way. Whereas a typical chart is designed to professionally show as much data as possible, and is set off from the flow of text, sparklines are intended to be succinct, memorable, and located where they are discussed. Sparklines are small enough to be embedded in text, or several sparklines may be grouped together as elements of a small multiple.

Contents

History

In 1762 Laurence Sterne used typographical devices in his sixth volume of The Life and Opinions of Tristram Shandy, Gentleman to illustrate his narrative proceeding: "These were the four lines I moved through my first, second, third, and fourth volumes,–". [1]

Illustration from the "Life and Opinions of Tristram Shandy, Gentleman" Sparkline of the narrative structure of the first three volumes of Tritram Shandy, accouring to the author.png
Illustration from the "Life and Opinions of Tristram Shandy, Gentleman"

The 1888 monograph describing the 1883 eruption of the Krakatoa shows barometric signatures of the event obtained at various stations around the world in the same fashion, but in separate plates (VII & VIII), not within the text. [2]

A 1999 screenshot of an implementation of sparklines developed around January 1998. The concept was developed by interaction designer Peter Zelchenko in conversation with programmer Michael Medved, while Medved was developing the QuoteTracker application. The product was later sold to Ameritrade. Screenshot of Sparklines in Medved QuoteTracker, 1998.png
A 1999 screenshot of an implementation of sparklines developed around January 1998. The concept was developed by interaction designer Peter Zelchenko in conversation with programmer Michael Medved, while Medved was developing the QuoteTracker application. The product was later sold to Ameritrade.

In 1983, Edward Tufte had formally documented a graphical style, then called "intense continuous time-series", encouraging extreme compaction of visual information. [4] In early 1998, interface designer Peter Zelchenko introduced a feature called "inline charts", designed for the PC trading platform Medved QuoteTracker. This is believed to be the earliest known implementation of sparklines. [5] In 2006, the term sparkline itself was introduced by Edward Tufte for "small, high resolution graphics embedded in a context of words, numbers, images". [6] [7] Tufte described sparklines as "data-intense, design-simple, word-sized graphics". [8]

Subsequent to his origination the term "sparkline", in 2020 Tufte attributed the origination of "sparkline-like inline graphics" to Donald Knuth's "METAFONTbook". [9]

On May 7, 2008, Microsoft employees filed a patent application for the implementation of sparklines in Microsoft Excel 2010. The application was published on November 12, 2009, [10] prompting Tufte [11] to express concern at the broad claims and lack of novelty of the patent. [12] On 23 January, 2009, MultiRacio Ltd. published an OpenOffice.org extension "EuroOffice Sparkline" to insert sparklines in OpenOffice.org Calc. [13] On March 3, 2022, LibreOffice developer Tomaž Vajngerl announced a new implementation of sparkline for LibreOffice Calc, including the support to import sparklines from OOXML Workbook format, and this is landed at 7.4 release. [14]

Usage

Sparklines are frequently used in line with text. For example:

The Dow Jones Industrial Average for February 7, 2006 Sparkline dowjones new.svg .

The sparkline should be about the same height as the text around it. Tufte offers some useful design principles for the sizing of sparklines to maximize their readability. [7]

See also

Related Research Articles

<span class="mw-page-title-main">Laurence Sterne</span> Anglo-Irish writer and cleric (1713–1768)

Laurence Sterne was an Anglo-Irish novelist and Anglican cleric who wrote the novels The Life and Opinions of Tristram Shandy, Gentleman and A Sentimental Journey Through France and Italy, published sermons and memoirs, and indulged in local politics. He grew up in a military family, travelling mainly in Ireland but briefly in England. An uncle paid for Sterne to attend Hipperholme Grammar School in the West Riding of Yorkshire, as Sterne's father was ordered to Jamaica, where he died of malaria some years later. He attended Jesus College, Cambridge on a sizarship, gaining bachelor's and master's degrees. While Vicar of Sutton-on-the-Forest, Yorkshire, he married Elizabeth Lumley in 1741. His ecclesiastical satire A Political Romance infuriated the church and was burnt.

<span class="mw-page-title-main">Lotus 1-2-3</span> Spreadsheet software

Lotus 1-2-3 is a discontinued spreadsheet program from Lotus Software. It was the first killer application of the IBM PC, was hugely popular in the 1980s, and significantly contributed to the success of IBM PC-compatibles in the business market.

<span class="mw-page-title-main">Spreadsheet</span> Computer application for organization, analysis, and storage of data in tabular form

A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. The term spreadsheet may also refer to one such electronic document.

<i>The Anatomy of Melancholy</i> 1621 book by Robert Burton

The Anatomy of Melancholy is a book by Robert Burton, first published in 1621, but republished five more times over the next seventeen years with massive alterations and expansions.

OpenType is a format for scalable computer fonts. Derived from TrueType, it retains TrueType's basic structure but adds many intricate data structures for describing typographic behavior. OpenType is a registered trademark of Microsoft Corporation.

<span class="mw-page-title-main">Visual Basic (.NET)</span> Object-oriented computer programming language

Visual Basic (VB), originally called Visual Basic .NET (VB.NET), is a multi-paradigm, object-oriented programming language, implemented on .NET, Mono, and the .NET Framework. Microsoft launched VB.NET in 2002 as the successor to its original Visual Basic language, the last version of which was Visual Basic 6.0. Although the ".NET" portion of the name was dropped in 2005, this article uses "Visual Basic [.NET]" to refer to all Visual Basic languages released since 2002, in order to distinguish between them and the classic Visual Basic. Along with C# and F#, it is one of the three main languages targeting the .NET ecosystem. Microsoft updated its VB language strategy on 6 February 2023, stating that VB is a stable language now and Microsoft will keep maintaining it.

<span class="mw-page-title-main">Edward Tufte</span> American statistician

Edward Rolf Tufte, sometimes known as "ET", is an American statistician and professor emeritus of political science, statistics, and computer science at Yale University. He is noted for his writings on information design and as a pioneer in the field of data visualization.

<span class="mw-page-title-main">Presentation program</span> Software package used to display information in the form of a slide show

In computing, a presentation program is a software package used to display information in the form of a slide show. It has three major functions:

Vector Markup Language (VML) is an obsolete XML-based file format for two-dimensional vector graphics. It was specified in Part 4 of the Office Open XML standards ISO/IEC 29500 and ECMA-376. According to the specification, VML is a deprecated format included in Office Open XML for legacy reasons only.

<span class="mw-page-title-main">Chartjunk</span> Term for unnecessary visual elements in charts

Chartjunk consists of all visual elements in charts and graphs that are not necessary to comprehend the information represented on the graph, or that distract the viewer from this information.

<span class="mw-page-title-main">Infographic</span> Graphic visual representation of information

Infographics are graphic visual representations of information, data, or knowledge intended to present information quickly and clearly. They can improve cognition by using graphics to enhance the human visual system's ability to see patterns and trends. Similar pursuits are information visualization, data visualization, statistical graphics, information design, or information architecture. Infographics have evolved in recent years to be for mass communication, and thus are designed with fewer assumptions about the readers' knowledge base than other types of visualizations. Isotypes are an early example of infographics conveying information quickly and easily to the masses.

A pivot table is a table of values which are aggregations of groups of individual values from a more extensive table within one or more discrete categories. The aggregations or summaries of the groups of the individual terms might include sums, averages, counts, or other statistics. A pivot table is the outcome of the statistical processing of tabularized raw data and can be used for decision-making.

This is an overview of software support for the OpenDocument format, an open document file format for saving and exchanging editable office documents.

Data Interchange Format (.dif) is a text file format used to import/export single spreadsheets between spreadsheet programs.

An IFilter is a plugin that allows Microsoft's search engines to index various file formats so that they become searchable. Without an appropriate IFilter, contents of a file cannot be parsed and indexed by the search engine.

Office Open XML is a zipped, XML-based file format developed by Microsoft for representing spreadsheets, charts, presentations and word processing documents. Ecma International standardized the initial version as ECMA-376. ISO and IEC standardized later versions as ISO/IEC 29500.

<span class="mw-page-title-main">Data and information visualization</span> Visual representation of data

Data and information visualization is the practice of designing and creating easy-to-communicate and easy-to-understand graphic or visual representations of a large amount of complex quantitative and qualitative data and information with the help of static, dynamic or interactive visual items. Typically based on data and information collected from a certain domain of expertise, these visualizations are intended for a broader audience to help them visually explore and discover, quickly understand, interpret and gain important insights into otherwise difficult-to-identify structures, relationships, correlations, local and global patterns, trends, variations, constancy, clusters, outliers and unusual groupings within data. When intended for the general public to convey a concise version of known, specific information in a clear and engaging manner, it is typically called information graphics.

<span class="mw-page-title-main">Quick View</span> Windows file viewer software

Quick View is a file viewer in Windows 95, Windows 98 and Windows NT 4.0 operating systems. The viewer can be used to view practically any file.

<span class="mw-page-title-main">Go-oo</span> Discontinued office suite software

Go-oo is a discontinued free office suite which started as a set of patches for OpenOffice.org, then later became an independent fork of OpenOffice.org with a number of enhancements, sponsored by Novell.

The Office Open XML file formats are a set of file formats that can be used to represent electronic office documents. There are formats for word processing documents, spreadsheets and presentations as well as specific formats for material such as mathematical formulas, graphics, bibliographies etc.

References

  1. Laurence Sterne, Life and Opinions of Tristram Shandy, Ann Ward (vol. 1–2), Dodsley (vol. 3–4), Becket & DeHondt (vol. 5–9), 1759-1767
  2. Symons, G. J., Judd, J. W., Strachey, S. R., Wharton, W. J. L., Evans, F. J., Russell, F. A. R., ... & Whipple, G. M. (1888). The eruption of Krakatoa: And subsequent phenomena. Trübner & Company. Plate VII
  3. Zelchenko, Peter; Medved, Michael. "Medved QuoteTracker screenshot". Wayback Machine. Internet Archive. Archived from the original on 13 October 1999. Retrieved 1 December 2015.
  4. Tufte, Edward (1983). The Visual Display of Quantitative Information. Quoted in "ET Work on Sparklines". Retrieved from http://www.edwardtufte.com/bboard/q-and-a-fetch-msg?msg_id=000AIr.
  5. "WaybackMachine snapshot from October 13, 1999, see "Screen Shots"". Archived from the original on 1999-11-27.{{cite web}}: CS1 maint: unfit URL (link)
  6. Bissantz & Company GmbH. "Sparklines: Another masterpiece of Edward Tufte". Archived from the original on 2007-03-11.
  7. 1 2 Edward Tufte (November 2013). "Sparkline theory and practice". Edward Tufte forum.
  8. Edward Tufte (2006). Beautiful Evidence. Graphics Press. ISBN   0-9613921-7-7.
  9. https://twitter.com/EdwardTufte/status/1509619247625949190?lang=en | accessdate = 2024-04-17
  10. "Sparklines in the grid". 2009-11-12. Retrieved 2009-11-19.
  11. "Sparklines in Excel". 2009-07-17. Retrieved 2009-11-20.
  12. "Microsoft makes patent claim for Sparklines". 2009-11-19. Retrieved 2009-11-19.
  13. "EuroOffice Sparkline | OpenOffice.org repository for Extensions". Archived from the original on 2009-01-26. Retrieved 2018-07-06.
  14. Vajngerl, Tomaž (2022-03-08). "Sparklines in Calc" . Retrieved 2022-03-09.

Further reading