Metro UI style Excel dashboard

Windows_8_Start_ScreenEarlier this week a friend and I were discussing the “Metro UI” style which is used in the new Windows tablets / phones and the Windows 8 start screen (seen to the left, picture taken from Wikipedia).  You’ve probably seen it splashed across your favourite US or UK TV programme recently (probably several times – product placement has been huge).

Based on the classic Swiss graphic design, initial reviews of the style were favourable.  It uses clean typography, simple graphs and bold colours.  It has even won several graphic design awards.  Apparently though, Microsoft is currently calling the style “Modern UI” or “Microsoft design language” due to a legal battle with Metro AG.

Despite the cleaner look, I personally don’t like the new style.  Too colourful and haphazard for my taste, though the animation is inspired.  I will always prefer a clean white space – I do so love my Apple products…

That being said, my friend set me the challenge of creating a (relatively) simple metro style Excel dashboard for my training teams.  Since the challenge was an interesting one I accepted.  Here is a picture of the basic result below.

Excel - metro

Obviously I have taken a few liberties with the style.  I’ve used the new Segoe UI font that Microsoft uses, but there is a lot of additional text in the report.  The background is slightly different, though I have tried to incorporate the actual colours used.  The final result though, looks much less clean than the Microsoft version.  I guess I have to give Microsoft props after all, it’s not easy creating something clean.  Also, the main redeemable features of the Metro style – animation of the brightly coloured squares and rectangles is currently missing in the training dashboard.  Since this report isn’t going to change, there is currently no animation.  However I may add that in later!

You can if you wish download the sheet I used here.  Feel free to incorporate it into your own reporting if you feel the need.  It’s a simple dashboard and doesn’t incorporate any interactive features, but I think you can recognise the Metro UI style.

What do you think?

Alesandra Blakeston

21 thoughts on “Metro UI style Excel dashboard

  1. Hi Alesandra,

    I am just having a look at the excel template. Is there a way I can modify labels on the charts and axis value? The tab is locked.

  2. This is awsome.. Like you said, maybe even a tad cleaner than what microsoft have done.. 🙂
    I was trying to customize it a little for my own dashboard, but it seems the cells are all locked.. Would you be able to tell me the password by any chance?

  3. Hai,
    Thanks for the template. I have one question, i just try to export this template to powerpoint but it give me error. Can you help me?

  4. Amazing is the word how i describe these Dashboard …gr8 going thanks for sharing 🙂

  5. Olá Alessandra Blakeston, ví essa matéria em uns dos links do excel ( que vou clicando clicando até chegar em você gostei muito muito do seu DASHBORD, haveria a possibilidade nos enviar esse arquivo para que eu possa aprender um pouco mais, Meu nome é Aparecido Diniz de Moraes e tenho 55 Anos e sou contador.

    Hello Alessandra Blakeston , saw that matter in each excel links ( ) I’ll clicking clicking to get you liked very much of its Dashbord , there would be the possibility to send us this file so I can learn a little more , my name is Diniz Aparecido de Moraes and 55s and I ‘m an accountant

    Usei o Tradutor do Google.
    I used Google Translate

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s