Article source: CMDGroup
Yes, I’m an economist first, but in my secondary role as ‘tech whiz’ – my wife and kids would guffaw at that assertion – I’ve come across an exciting feature of standard Excel spreadsheets that I feel must be shared with you.
Of course, there’s always the danger that I’ve finally clued in to something everybody else has known about for years. However, I’ve asked around and it seems most people aren’t yet aware of a tool called ‘Sparklines’ that is highly worthwhile.
And neat and cool and easy to use.
Let’s suppose you have a ‘wall’ of data, such as appears in Table 1 that accompanies this Economy at a Glance. I’ve included the row numbers and column letters for ease of explanation.
The statistics in cells ‘C2’ diagonally to ‘O22’ are percent changes of U.S. put-in-place construction investment, latest 12-month averages versus previous 12-month averages.