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
Add Multiple Percentages Above Column Chart or Stacked Column Chart
I recently posted a tutorial on how you can put a percentage at the top of a Stacked Column Chart. You can see the...
Connect Line Data Points
How-to Connect Gaps in a Line Chart in Excel
When you are build your Excel Dashboard Template charts, you may find that some of your data is not complete. For instance, you may...
Column Chart
How-to Create Sales Quota Threshold Horizontal Lines in an Excel Column Chart
Sales executives are always pushing their sales teams. They typically do this by setting sales quota’s for their salespeople. Quotas are thresholds or minimum...
Chart
How-to Make Longer Legend Color Bars in an Excel Chart Video Tutorial
Most Excel 2D Column Charts have small color boxes in the legend to point you to the right series in the graph. However, this...
Chart
Create a Dynamic Excel Pie Chart
How-to Create a Dynamic Excel Pie Chart Using the Offset Function
Recently, I viewed a forum post where a user wanted to create a dynamic...
Excel
Remove The Zero Point or Make a Hole in an Excel Radar Chart
As my lovely wife recently stated, Excel Radar Charts are COOL! I kind of agree.
That is why when I recently saw an Excel question...
