5 August 2009 by Ross McLean
Don’t get me wrong. I’m looking forward to having spark/spike lines out of the box. In fact, I even asked for it!(See 3rd comment), and I think MS have done a bang up job (from what I’ve seen).
But this is what’s playing on my mind. How many Excel users even know what sparklines are? I would say with some confidence that it’s less than 0.5%.

How then does this fit with the idea of the Ribbon UI, which is designed for the (apparent) 90% of Excel users that can’t read and click a lists of words! – (menus). I know this arguments flaky, but I hope you can see my point, I know that the UI team is from a different part of MS than the Excel guys. But in my head it doesn’t stack up. Has the charting engine been fixed?
I’ve not actually touched 2010, but I just feel that after the relative disaster of 2007, it would not have been the first thing I’d have started working on. I hope they’ve ironed out all the over issues, they’ve had 13 years to work on 3D charts!
BTW, sparklines for Excel are not new, there are a number of addins that can make backwards compatible spike lines, relatively easily.
Free ;-)
http://www.spreadsheetml.com/products.html [bit pants]
http://www.bloggpro.com/nanocharts-milestone-release-v051/ [my fav]
http://sparklines-excel.blogspot.com/ [most comprehensive]
Paid
http://www.bonavistasystems.com/
http://www.bissantz.com/sparkmaker/index_en.asp
Tags: Charts, Sparklines
Categories: Charting •
11 Comments »
31 July 2009 by Ross McLean
Advances in Excel lightboxes! I’m not sure about you but my spreadsheet is just not complete unless I have some sort of lightbox viewer going on.
Juice have an example here, I have approached it in a slightly different way, and linked to a chart via a picture control, the example work book can be downloaded below.

And if you liked Advances in Excel lightboxes stay turned for Advances in Vista like buttons from shapes….what a world we live in.
Here’s the file: M.I.E Light Box
Tags: Charts, Downloads
Categories: General, Spreadsheet Design, White Noise •
9 Comments »
5 March 2007 by Ross McLean
Sometimes I trawl the internet trying to find new ideas. Quite often it’s charts and graphics that I’m looking for. This stopped me dead in my tracks and I had to post about it.

Phenomenal! Talk about pointless!
Soucre: http://www.infosoftglobal.com/FusionCharts/IS/Demos/Literacy/Index.html
Tags: Charts, WTF
Categories: Charting •
5 Comments »
12 August 2006 by Ross McLean
A few ideas have been floating about recently, each have there own pros and cons here a new one to me, looks good!
http://www.juiceanalytics.com/weblog/?p=239
Tags: Charts
Categories: Charting •
No Comments »
25 January 2006 by Ross McLean
Sometimes we want to hide our data but still display the values in a chart. By defult Excel will remove the chart content when we hide rows or colunms.
The answer is to change a setting in the Excel Maze, sorry options box.
Select the chart you wish to change then goto: Tools > Options > ;Chart
then unselect the “Plot Visible Cells Only” option.
Another option to consider is putting the data in another worksheet then hiding that sheet.
Tags: Charts, Examples, Tips
Categories: Charting •
No Comments »