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
Chart
How-to Plot Building Wall UR Value in an Excel XY Scatter Chart
In an Excel Help Forum, an engineer wanted to know how to chart the following data:
The data would need to be plotted like on...
Chart
Charting Specifications and Limits for Excel 2003, 2007 and 2010
Have you ever wondered how many data series you can actually add to an Excel chart? Well there are limits. Recently an Excel Client...
Chart
How-to Highlight or Color Rings in an Excel Radar Chart
Recently a user in an Excel Forum wanted to know if there was any way to highlight or color the outside ring of an...
Dashboard
How-to Quickly Mock-up Data for a Dashboard Template
I frequently need to create and test a chart design concept for Excel Dashboards. Therefore, I need chart data that is representative of the actual data,...
Dashboard
Titanic Mortality Dashboard
Today marks the 100th anniversary of the tragic sinking of the RMS Titanic. On that fateful day, over 1,500 people died when the Titanic...
Chart
Add % Difference Data Labels to Excel Horizontal Tornado Chart
Okay, the client is always requesting changes. How do you deal with these? I suggest increasing the contracted hours. In this case, I decided...
