Pimp Your Dashboard
Here is a real data visualization question: how to pimp your dashboard? If you are excel power user and bored with old templates then you should have a look at brand new design and layout.
Considering the features in this dashboard tool use the built in Excel shapes, they are fully customizable.
The component that populates your dashboard is just a grouped set of standard shapes. Pimp your dashboard and excel reports and link your Infographic to your data. It is cool!
Our ready to use shape set contains top quality excel infographic elements you can use in presentations or dashboard templates.
You can apply the standard excel tools: Move, resize or delete specific shapes; swap fill color or font color; change shadow settings or apply gradients. You can also link shapes to selected cells.
OK, some cool dashboard widget waiting for you. Download the collections!
Pimp your Dashboard – Must have tools
To build the list of options is to type them on a worksheet. We can do this method on the sheet that will have the dropdown lists, or on a different worksheet. In most cases the excel list will be stored on a sheet named ‘Lists’.
Using conditional formatting you can create a rule (or rules) based on the selected cell’s contents. For example set conditional formatting, so that a cell turns green if the cost is low, and turns red if cost is high.
It’s very useful if you develop a sales performance report, balanced scorecard or a simple kpi dashboard.
Sparklines aka mini chart (or in cell chart) is a standard dashboard element. We suggest to use sparklines to present time series data or visualizing trends. Here is an example to try it!
Active report elements like form controls or pivot table slicers suggest to play with the chart. We recommend that to create interactive excel dashboards. If you can play download our form controls example!
Gauges and speedometers are our personal favourites in Excel. We have some free dashboards for you, visit the gauges area!
We’ll use traffic signals as a status for actual KPI value. If the green traffic light is active that the performace is great, the red light indicate the weak performance.
Our latest template using these tools.
A common way to choose KPIs is to apply a balanced scorecard or a sales dashboard.