This is a quick and easy one, but essential if you use a lot of auto shapes on your dashboard. To make some space along the top you want to rotate the text heading 90 degrees so it is displayed to the side of the table. Click on the auto shape containing the Read More …
Category: Dashboard tricks
Adding a scroll bar in Excel
This article will demonstrate how to add a basic scroll bar in Excel with an example of how it could be used on your dashboard. We’ve taken a full year of ATP tennis matches from 2015 (credit to www.tennis-data.co.uk for the source data). The dashboard is going to show tennis stats by month and the Read More …
Using the Camera tool on your Excel dashboard
The Camera tool is a little known Excel function which can be helpful in several situations. Probably the most obvious is on your dashboard report. You’ve been asked to make some changes, add something new into the dashboard, but it’s a nightmare because you have to spend hours adjusting all the column widths and merging cells Read More …
Excel pivot table only showing top 10 values
You might want to pull in a select number of values from your pivot table into your dashboard report i.e. the top 5, top 10, bottom 10, etc. To do this as a one-off is simple, but to do this dynamically (so the dashboard updates the top 10 as the data changes in the background) Read More …
Aligning objects in your Excel dashboard
Your dashboard will typically have a number of different objects, maybe some text boxes, shapes and charts, etc. As you’re building it up and making changes if you find it’s taking lots of manual time lining everything up, you may find this tip useful. In this simple example, we just have two charts we Read More …