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 vs Actual Excel Dashboard.
Not...
Clustered Stacked Bar 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 and we can user...
Clustered Stacked Bar Chart
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 Clustered Stacked and Multiple...
Uncategorized
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 reminder that the awesome...
Chart
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 anymore. Check out the...
Chart
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 post. If you don't...
Explore more articles
Budget Analyst
Budget Analyst Question: My Answer
Last week I posted this:
Budget Analysts might be asked by their executive team, managers or co-workers.
Question Title: Bar Graph Below the Line
I need a...
Chart
The Tricks to Writing a Conditional Formatting Rule Formula
When you build your Excel Dashboard, you will frequently want to use Conditional Formatting to create color callouts and other table based dashboard components. ...
Budget Analyst
Budget Analysts – How would you answer this Excel Chart question?
Two months back there was a posting in the Mr. Excel forums that I thought most budget analysts might be asked by there executive...
Chart
How-to Show Excel Chart Data and Keep Chart Size when Hiding Spreadsheet Columns and Rows
Many times when you are building your Excel Dashboard Templates, you will want to hide rows or columns in the same area as your...
Axis Formating
How-to Create a New York Times Tiger Woods Chart in Excel
In a past article, I posted 2 different ways to make a chart that appeared in the New York Times. Here is the chart...
Axis Formating
How-to Make a Wall Street Journal Horizontal Panel Chart in Excel
In a recent Wall Street Journal article I saw the following chart regarding Dropbox, YouSendIt and Box.com. The graph describes how many people use...
