The concept sparkline was invented by Edward Tufte, as presented in Wikipedia: Edward Rolf Tufte, born in 1942 (Kansas City, Missouri, USA) is a professor of statistics, computer science, information design and political economy at Yale University. It has been described by The New York Times as the "Leonardo da Vinci of data" . Note that, unlike some French writers, including a recent Goncourt winning journalist and a famous, I do not mind ... to quote my sources
Microsoft filed the patent in May 2008, to the chagrin of Edward Tufte and others and professionals (see http://www.edwardtufte.com/bboard/q-and-a-fetch-msg?msg_id=0003Y1&topic_id=1 ). Hopefully all this will find a solution ... honest
A sparkline is a graph that fits in a single cell in your spreadsheet. Initially, it was only curves (hence the term "line"). The sparklines are in Excel, through various add-ins (or supplements) for several years already.
These graphics are built into Excel since the 2010 version of the software. We see in a later article how to proceed with earlier versions of Excel.
In this first article we see how to create a first sparkline with Excel 2010: the cursor is in D2, we activate the tape "Insert" and activate the curves tool in Block "sparkline Charts." Here's how we filled dialogue:
The result is shown below, with further two new graphs with, for the same set of digital data, the histogram and the corresponding positive / negative partner.
Note 1 - In version "Positive / Negative", there is no indication of the absolute value, but only the distinction Positive / No / Negative.
Note 2 - The histogram default can not see well that there are negative values in the series, but we'll see how to fix this in the next section.
0 comments:
Post a Comment