About this template
A template for a layout worth using far more often: when a page needs both a dashboard and the data behind it, split it — reserve the top rows for the dashboard and put the data table underneath. The text boxes and charts are all linked to that table, so they update when it changes.
Good to know: this is built as a reference file to study and customize, not a drag-and-drop template. You connect your own data and adjust it to fit — that's the point. You learn exactly how it's made.
What's included
- A split-page layout: dashboard on top, data table beneath
- Text boxes and charts linked to the table, so they update live
- A reusable pattern for pages that need both data and visuals
How it works
Study how the split layout and the links between the visuals and the table are set up, then rework it around your own data. Like the other reference files, expect a fair amount of customization to fit your structure.
Who it's for
Anyone building a report that has to show both the numbers and a clean dashboard on one page.
Excel compatibility
Designed for Microsoft Excel on Windows and Mac — Microsoft 365 or Excel 2021 recommended. Built for Excel, not Google Sheets.