Inserting cell values into shapes in Excel - the 1st step to building dynamic dashboards

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.

[RexorLeet]

Bing gpt was having trouble answering this, your video finally helped me!

[MrMeghdadi]

learned something useful from you, thanks

[Levitator]

Brilliant mate. Exactly solved the problem i was having 👍

[HooseOfWidnes]

You could use a spinner and =index against the range of data so you could click up and down to cycle through the months, the format would stay the same.

[cx]

What if next month I want Jan to show automatically instead of doing it manually

[TheBattlesEnd]

Is there a way to put a dynamic pivot table in a shape for a dashboard?

[giustibruno]

Is there a way to do it the other way around? Reference the data from a shape into a cell?