Tag: Charts

Sparklines in Excel 2010 – why?

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%.

Sparklines in excel 2010

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

Excel Lightbox Viewer

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.

MIE LightBox

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

The best chart in the world Ever!

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.

ChartsOfDoom.PNG

Phenomenal! Talk about pointless!

Soucre: http://www.infosoftglobal.com/FusionCharts/IS/Demos/Literacy/Index.html

In cell graphing

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

Hidden data and Charts

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.