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.

Tags road, traffic, statistics, Excel, Charts, charting, Dashboard