How-to Make a Conditional Column Chart in Excel
As you build your Microsoft Excel dashboards, you may want to highlight your data points that exceed your Key Performance Indicators (KPIs) as well...
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. ...
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...
How-to Make a Non-Chart Excel Dashboard Chart (Heat Index)
So I saw this chart in an Excel forum and a user was asking this:
“chart - not sure about this one
I've created a...
How-to Show Gaps in a Line Chart When Using the Excel NA() Function
In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart. In essence, he wanted to...
