LATEST ARTICLES

Actual vs Plan Excel Dashboard

How-to Build a Plan vs Actual Excel Dashboard

Hi All, I wanted to share with you a great post from a fellow Excel creator and teacher. Mynda Treacy has just released a great video tutorial on how to create your own Plan...
Clustered Stacked Column Chart

How-to Make an Excel Clustered Stacked Column Chart Type

How-to Make an Excel Clustered Stacked Column Chart Type Have you been able to find the Excel Clustered Stacked Column Chart Type? Well it is not there, unfortunately. But Excel is a powerful tool...

How to Make a Clustered Stacked and Multiple Unstacked Chart in Excel

How to Make a Clustered Stacked and Multiple Unstacked Chart in Excel On my post How-to Create a Stacked and Unstacked Column Chart I received a comment on how can we do this for a...

Free Excel Dashboard Webinars & Excel and Power BI Dashboard Courses

Hi Everybody, I'm excited to share with you a Microsoft Excel MVP, Mynda Treacy's, highly acclaimed Excel Dashboard course.  More details are below. - STEVE=TRUE Hurry, Last Chance for Free Dashboard Webinars & Course Just a quick...

How to easily change chart element selections in Excel 2016 2019 and Office 365

Selecting chart elements changed in Excel 2016 2019 and Office 365. Learn how to easily change chart element selections with this quick tip. The technique you used in previous versions of Excel don't work...
Fix Error Current Sales Greater than Sales Goal - Thermometer Chart in Excel

How-to Fix Sales Goal Error of Excel Thermometer Chart

How-to Fix Sales Goal Error of Excel Thermometer Chart I have to admit that I messed up and presented a broken solution for the Excel Sales Goal Thermometer Chart. The error was presented in this previous...
Hack Excel Protect Workbook

How-to Hack Excel Protect Workbook Feature When You Forgot the Password

Hack Excel Protect Workbook So you forgot / lost your password and need to update your workbook tabs or structure? Well don't cry, don't complain, we can Hack Excel Protect Workbook feature with this...

How-to Fix a FRUSTRATINGLY Annoying Excel Scroll Lock Issue

Check out this simple technique if you have pressed the wrong keys on your keyboard and can't stop Excel from scrolling instead of moving cells when you use your arrow keys. https://www.youtube.com/watch?v=2yWsl3XlUAs Steve=True
Create Vertical Line Between Columns in Excel with Error Bars

Create a Vertical Line Between Columns in Excel Using Error Bars

Create a Vertical Line Between Columns in Excel Using Error Bars Thanks to Leonid (a super fan) for advising me on another and possibly better technique to create a vertical line between columns in your...

Add Vertical Line Between Columns in Excel Stacked Column Chart

Add Vertical Line Between Columns in Excel Stacked Column Chart In this tutorial, you will learn how to QUICKLY add a vertical line between columns in a stacked column chart to visually separate your graph...