Pimp Your Dashboard

Pimp Your Dashboard updated

Pimp Your Dashboard

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

Data validation

pimp your dashboard feat

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’.

728x90

Conditional formatting

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

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!

Form Controls

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

Gauges and speedometers are our personal favourites in Excel. We have some free dashboards for you, visit the gauges area!

Traffic Lights

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.

728x90