Infographics in Excel

Infographics in Excel is not a new concept but these sort of graphical representations are very powerful and convey a striking message.  Infographics are usually not as dynamic as a dashboard, they tell a striking story.  This is not to say that the source data which populates the infographic can't be dynamic in nature. 

My website is about to explode with Infographics as I publish a swath of interactive Excel Infographics for people to plug and play with.

Read More

Road Traffic Statistics in Excel

While going through some road traffic information on the Department of Transport's website it occurred to me that the data was perfect to create a dashboard.  It was information rich and there were very little gaps in the data.  I decided to use quite a few pictures in conjunction with the charts to try and spice them up.  I have used actual data but had to ‘normalise’ some of the data as there were a few gaps.

Read More