Excel Dashboards

The Excel Dashboard Page serves as a Table Of Contents for all Excel Dashboard related content in the XLCubed Company Blog.

Organizing Excel Dashboards

• The Layout of the Dashboard Page, The Camera Tool

Dashboard Data Management – Great Ways to Pull Data in Your Dashboard

• Data sources for Excel Dashboards: Avoid Spreadsheet Hell
• Excel Lookup functions
• Dynamic Query Tables
• Measures, Dimensions, OLAP and MDX
• Context Rich Measures with Cube Formulas
• More Insight with Visual Grids

Dashboard Delivery : Screens, Printer And the Web

• Sharing your Excel Dashboard: from Paper to the Web
• Publish your Dashboard to the Web

Adding Interactivity without Programming

• The Missing Link
• Data Dynamic Dashboards

Visual Design

• The Dashboard Squint Test
• Gestalt Laws for Charts and Tables
• Colors for Charts and Tables that work
• Effective Fonts for Excel Dashboards

Excel Table Design

• Number formats
• Table Alignment
• Delineate Rows and Columns
• Layering Table Components
• Creating Rounded Corners in Excel Tables
• Hermann Grids, An optical Illusion Best Avoided

Chart Design

• Chart Rules, As Simple as Possible, But Not Any Simpler!
• Layering Chart Components

Charts to Show Time Series

• Sparklines and MicroCharts
• Small Excel Charts

Charts to Measure performance against a target

• In-Cell Variance Charts
• Bullet Graphs

Charts to Rank

• Bumps Charts
• Ranking Tables

More Excel Dashboard Resources

• Recommended Blogs, Books and Online Resources