What can you learn from Excel for Web Dashboards?

Posted on 27 Nov 2013 in   Big Data, Information

Excel is a great tool. A great enough tool that almost 90% of analysts still use it for something or the other. It is not a renowned visualization tool but there are research firms who earns their bread and butter through primarily using excel for analysis.

Excel’s visualization capabilities has still a lot to catch up on but there are things which we consider standards which needs to be ported out to Web Dashboards.

 

Here are 5 Excel techniques which you definitely need on a Web Dashboard :

 

  • Creating Clear Headers

Excel has a function where you can ‘bold’ a text.  Actually almost all text editors or spreadsheet products out there has that feature where you can bold a text. This helps the user easily mark different sections in a dashboard.

excel-header-dashboard

 

 

 

 

 

 

 

 

 

  • Using colors to highlight key data

Colors can be used to highlight key data. This is a feature which can help highlight key aspects in a web dashboard.

excel-highlight-key-data-web

 

 

 

 

 

 

 

  • Striping for easy reading

When you have a long list of tabular data, tracing data lengthwise becomes troublesome . This is another simple technique to help with easy reading of raw data in your dashboard.  By the way, displaying raw data (without aggregation or filtering) is not recommended but there are cases when you do need to publish raw data.

excel-striped-layout-dashboard

 

 

 

 

 

 

 

 

 

 

 

 

  • White space where needed

Adding whitespace in Excel is easy. Insert a row !.  If you enable this on your dashboard, this is another simple but powerful way to make your dashboard better looking.