Advanced Excel, Dashboards, Data Visualizations, General, No VBA

Microsoft Excel Visio Data Visualizer Add In for Excel: A Quick Guide

IntroductionI wanted to let you know about a really cool new add in for ...

 ​Read More

Advanced Excel, Analysis, Dashboard Tips & Tutorials, Dashboards, Data Visualizations, General

Highlighted Timeline Chart in Excel Without VBA: Raw and Uncut

Introduction I built a chart that let’s you highlight a series from a smaller ...

 ​Read More

Advanced Excel, Analysis, Dashboard Tips & Tutorials, Dashboards, Data Visualizations

Excel Data Visualization: Presidential Approval Ratings with Slicers & Power Query – Chart Tricks

No matter where you fall on the political spectrum, you'll love the chart I've ...

 ​Read More

Dashboards, Data Visualizations, Discussion

Three Common Dashboard Mistakes

I recently contributed to the article on MRC’s Cup of Joe Blog called 7 harmful ...

 ​Read More

Dashboards, Data Visualizations, No VBA

Auto highlighting Excel charts

On your dashboards, reports, and charts it’s a good idea to alert the user ...

 ​Read More

Dashboards, Data Visualizations, Development, No VBA, Spreadsheet Tricks

Custom Formats for Dashboards and Spreadsheet Applications

Conditional formats are volatile. If you have too many, you see the effects of ...

 ​Read More