Interactive Dashboard Step by Step + FREE File Download

Introduction

In this tutorial, you will learn how to create an interactive Excel dashboard with a dark theme. This step-by-step guide will walk you through the entire process, from preparing your canvas to creating various charts and adding interactive elements. The techniques you will learn will help your data stand out and provide a visually appealing presentation.

Step 1: Prepare the Dashboard Canvas

• Open a new Excel workbook.
• Set the background color to a dark theme by selecting the entire sheet and changing the fill color.
• Adjust the gridlines by going to the "View" tab and unchecking the "Gridlines" option for a cleaner look.

Step 2: Get the Data with Power Query

• Go to the "Data" tab and select "Get Data."
• Choose your data source (e.g., Excel file, online data, etc.).
• Use Power Query to import and transform your data.
  • Filter necessary columns.
  • Remove any unwanted rows or duplicates.
• Load the cleaned data into Excel for further analysis.

Step 3: Create Doughnut Charts

• Select the data you want to visualize.
• Go to the "Insert" tab and choose "Doughnut Chart."
• Format the chart:
  • Right-click and select "Format Data Series."
  • Adjust the hole size to your preference.
  • Change the colors to fit the dark theme.

Step 4: Create Top Column Charts

• Select the data for your column charts.
• Insert a "Clustered Column Chart" from the "Insert" tab.
• Format the chart:
  • Change the fill colors to bright shades that contrast against the dark background.
  • Adjust the axis titles and labels for clarity.

Step 5: Create a Map Chart

• Ensure your data includes geographical information (like country or region).
• Select the data and choose "Map" from the "Insert" tab.
• Format the map:
  • Use colors that pop against the dark background.
  • Add data labels for better readability.

Step 6: Create Additional Column and Area Charts

• Repeat the process for creating more column and area charts.
• Make sure to vary chart types to give a comprehensive view of your data.
• Customize each chart's design to maintain consistency in the dark theme.

Step 7: Add Slicers for Interactivity

• Select a PivotTable or chart that you want to filter.
• Go to the "Insert" tab and choose "Slicer."
• Choose the fields you want to use for filtering.
• Format the slicers to match the dashboard's theme.

Step 8: Enable Automatic Updating

• Make sure your data source is set to refresh automatically.
• Go to "Data" > "Queries & Connections" and set the refresh options.
• This ensures your dashboard reflects the most current data without manual updates.

Step 9: Create a Dashboard Header

• Use a text box to create a header at the top of your dashboard.
• Format the text box by adjusting the font size, style, and color to match the overall design.
• Include a title that clearly describes the dashboard's purpose.

Conclusion

You've successfully created an interactive Excel dashboard with a dark theme. This tutorial covered the essential steps, including preparing your canvas, importing data, and visualizing it through various charts. For further enhancement, consider exploring more advanced Excel features or taking a dashboard course for deeper insights. Happy dashboarding!