Put some numbers in A1:A6 (1,5,8,10,15,12)
In B1 enter =REPT("-",A1)
Copy down to B6
Adjust column width of B as needed
Try other symbols in place of "-"
That's how we did it in Fortran in the 60's
OR get Excel 2007
Bernard, that's not a sparkline. That's one number in a cell, expressed
as a column of a certain length. A sparkline is a series of numbers,
expressed as a tiny line or bar graph.
I have implemented sparklines in Excel, by simply creating a minimal
line or bar chart as an embedded frame, and dragging its corners into a
single cell while pressing the Alt key, to snap the frame to the cell
corners. The frame can then be moved, sized and copied with the cell,
although you'll have to change the data series it refers to by hand.
I find it's difficult to shrink the entire chart into one regular height
cell, so I double all the cell heights up and use 20 point text. If you
like, you can just snap it to two cells instead, but a true sparkline
should be the height of a single line of text.
Bissantz & Company GmbH offer a sparkline add-in for Excel called
SparkMaker:
http://www.bissantz.de/sparklines/sparkmaker.asp
This product takes a different approach: Bissantz have created a custom
font with bars, pies, dots and lines that, when used with their user
defined functions, creates a sparkline in the cell where the function is
entered. bonavistasystems.com also has a product called Microcharts, but
I haven't evaluated it.
