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
Bar Chart
How-to Center Excel Clustered Chart Columns Over Horizontal Category Labels
When you have several series
in one chart and only one of those series appear per Horizontal Label Category, you probably want to center the...
Bar Chart
Create a Excel Gantt Chart to Display a Music Festival Band Schedule
Here is Pete's answer to the recent Music Festival Schedule Challenge.
In this video, see how he used Index/Match functions as well as a helper...
Conditional Chart
How-to Make a Music Festival Schedule Using Excel Conditional Formatting
Recently, I saw an Excel User posting a question about how to make this Music Festival Schedule using Excel Charts.
However, he originally created the...
Challenge
Don’s Macro Enabled Friday Challenge Answer – Music Festival Schedule Excel Chart
In our last Friday Challenge, we wanted to see if you can make a Music Festival Schedule in an Excel Chart.
There were 2 questions. ...
Bar Chart
Friday Challenge – Create a Chart to Display a Music Festival Schedule
Here is an interesting question that I saw and I thought I would present it as the next in the series of Friday Challenges.
This...
Chart
How-to Graph Three Sets of Data Criteria in an Excel Clustered Column Chart
Here is a very simple solution to a common Excel Charting question when a user wants to graph “Three sets of data criteria on...
