Dashboard Secrets · ~1 min read

Excel's Live Picture Trick for Dashboards

Paste a range as a linked picture from the keyboard, watch it update live, and remove the gridlines that give it away.

Video link coming soon
What you will learn

Step by step

1. The layout problem

Dashboards fight the grid: one table needs wide columns, another needs narrow ones. A linked picture ends that fight.

Excel's Live Picture Trick for Dashboards: The layout problem
The layout problem

2. Paste a linked picture

Select the table and copy it with Control and C.

Click where the dashboard should show it, E2, and press Alt, H, V, I. That is Paste, Linked Picture.

It looks like the table, but it is a picture floating above the grid. You can move it or resize it, and the columns underneath never change.

Shortcut: Ctrl + C

Excel's Live Picture Trick for Dashboards: Paste a linked picture
Paste a linked picture

3. It stays live

And it is live. Press Escape, click B2, and type nine thousand for North.

The picture updates at once, because it is a window onto the cells, not a snapshot.

Excel's Live Picture Trick for Dashboards: It stays live
It stays live

4. The gridline trap

The trap: the picture copies everything it sees, gridlines included, so it looks like a piece of spreadsheet stuck on the dashboard.

Turn the gridlines off with Alt, W, V, G. That is View, Gridlines.

Now the picture is clean: just the table, sitting wherever you place it.

Would you build a dashboard from linked pictures? Tell me in the comments what you would put on it.

Excel's Live Picture Trick for Dashboards: The gridline trap
The gridline trap
What do you want to learn next? Tell us in the comments on YouTube: your requests decide the next tutorials.

← Previous tutorial: Excel Icon Sets: Why Zero Gets a Green Arrow
Next tutorial: Filter a PivotTable by Month in One Click (Timeline) →