Inserting cell values into shapes in Excel (updated & extended version 2023)

If you want to have dynamic metrics that you can move freely around your Excel dashboard, you need to insert the metric into a shape. It seems odd but it allows you to have way more flexibility when you layout your page. It also is the first step towards understanding how to start developing more complex layouts.

If you want this template or others like it, sign up for the newsletter where I send free templates each month: https://exceldashboardtemplate.com/ne...

If you want the full dashboard toolkit, you can find it here: https://exceldashboardtemplate.com/

00:00:00 Intro
00:00:50 How to do it
00:01:37 Padding is critical
00:01:59 Losing text formatting
00:03:08 Cell reference error
00:03:52 Handling PIvot Tables
00:04:41 Layout & Communication
00:06:32 Get the templates