KPI & card visuals in Excel (like Power BI)
HTML-код
- Опубликовано: 12 июл 2024
- Excel has no card visuals like Power BI or Google Sheets, but you can hack it together. Simple ones with just a number that can automatically change based on a slicer selection using shapes linked to a cell via formula, or more complex ones via "paste as linked picture" for trend line charts (sparklines) or colour changing squares (conditional formatting) and arrows for up / down via a formula with IF, TEXT and ABS functions. Finally, I also go through a slicer-dependent flag using Excel's geography data types and using "reference" from the pictures in cells.
Related videos:
Pivot Tables intro: • PivotTables but better...
Dashboards in Excel: • Interactive dashboards...
Interactive dashboards in Google Sheets including cards: • Interactive dashboards...
You can download the example files here: www.xlconsulting-asia.com/you...
00:00 Introduction
00:23 3 ways to link cells to objects
02:38 Pivots and slicers
03:55 Linked shapes tips
05:43 New Window
06:49 Other text boxes
08:02 Getting the flag
09:41 % change with up / down arrows
10:30 Avoid GETPIVOTDATA
14:10 Line chart / sparkline
15:19 Varied colour box
16:47 Icon
17:47 Slicers
18:51 Alignment tricks Авто/Мото