Скачать или смотреть How to Create a 3D Roadmap Template for a Dashboard in Excel

Learn how to make a 3D roadmap template for your Excel dashboard to visually represent project timelines, milestones, and key performance indicators. This tutorial covers step-by-step instructions on designing a structured roadmap using Excel’s built-in features, including shapes, gradients, and SmartArt. Enhance your data visualization and improve project planning efficiency with a clear, dynamic 3D roadmap. Perfect for business analysts, project managers, and data professionals.

Time Codes
00:00:39 Creating a template from shapes for further chart processing.
00:01:09 Building a 3D chart and drawing shapes in three-dimensional space.
00:10:24 Adding road markings to design the chart in a Roadmap style.
00:13:10 Using the chart for a masking effect to enhance interactivity.
00:19:31 Leveraging MS PowerPoint's editor to create a complex shape using Combine.
00:20:27 Combining a chart with a complex shape featuring cutouts and a mask overlay on multicolored segments.
00:25:33 Filling the source table of the Roadmap chart with formulas to extract data from an Excel smart table.
00:26:25 Adding a slicer for filtering by half-years and using it as a dashboard control element.
00:26:10 Best formula to extract only filtered values from an Excel smart table.
00:28:50 Creating a pivot table to add interactive buttons to the dashboard.
00:34:10 Adding dynamic data labels using Excel formulas.
00:43:53 Designing a dark version of the 3D Roadmap Chart in Excel.
00:50:39 Creating navigation cursor-shaped elements to decorate the Roadmap-style design.
00:53:24 Enjoying the final presentation of the 3D Roadmap Chart template made in Excel.

This tutorial walks you through the process of creating a 3D Roadmap Chart template in Excel, combining advanced visualization techniques with interactive elements. You’ll start by designing a base template using shapes, then move on to constructing a 3D chart with custom elements. The video demonstrates how to enhance the design with road markings, masking effects, and dynamic labels to create a more intuitive and visually engaging roadmap. You'll also learn how to integrate smart tables, formulas, and pivot tables to ensure flexibility and interactivity. By the end, you'll have a fully functional dashboard component that brings data to life with a professional, structured layout.