Posts Tagged Visualization

Getting help choosing the right chart type in Excel

As a follow-up to my previous post depicting a flow chart for choosing which type of chart can better emphasize our reporting needs, I dig up an Excel add in intending to help you in this task.

Published by Microsoft Office labs, the Chart Advisor add in for Excel “identifies, ranks, and displays an array of charts most relevant to you so you
can make the most out of your presentation.”

Though not very new (it was first published in may 2010), it’s worse mentioning it for those of you who may not have been aware of its existence. One last word to say that there is no Office 2010 version, it only works with Office 2007.

 

Leave a Comment

Having difficulties choosing the right representation for your data ? Try the “Chart suggestions” method …

So you want to propose convincing data representations ? Maybe have you sometimes difficulties choosing between all the form of existing charts the one that will best fit your needs ?

Some times ago, I was asked to discuss with a client involved in our dashboard design workshops, why to choose one kind of chart rather than another. Even if I knew well “instinctively” the different representations you can use for graphing trends or distributions for example, I was searching something formal and exhaustive to share with him, something that can guide him … even without me being around.

Read the rest of this entry »

Comments (1)

Do you like infographics ? Visual.ly is here for you

As business intelligence professionals, we all realize, sooner or later, and sooner is better :), that data is hardly actionable if not turned into information and that in the process of digesting info, data presentation and how it tells you the story does count a lot.

So I’m always interested when I come across a presentation that goes straight to the goal.

If like me you’re interested in infographics and more widely in data visualizations, here’s a great place to start with !!

Visual.ly‘s web site defines itself as “The world’s largest community for exploring, sharing, creating, and promoting data visualizations.”

It helps you to find and browse visualizations and infographics found on the web and to promote your own work.

One last feature should be the corner-stone of what this website will have to offer in the future. It’s a service that will allow you to craft your own infographics. It claims that it will not request any extensive habilities other than knowing what’s the story to tell. You can sign for an early access here.

As a bonus, here’s a short list of some of my favourites :

The tale of early tech rival

Difference between Humans and Animals

The student loan scheme

And you ? What are your favorite ones ?

Comments (3)