Our ready to use shape set contains top quality excel info-graphic elements you can use in presentations or templates.
You can apply the standard excel tools to improve your dashboard: 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.
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 drop-down 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 favorites 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 performance 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.