Case Study – Creating a Dynamic Chart in Excel Using Offset Formula
A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function. So Mili sent me the...
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...
Problems with an Excel Dashboard Goal Chart
A while ago, a user in an Excel help forum had a chart in his Excel Dashboard that was acting quite strange and he...
Another Reason to Avoid 3-D Charts in Excel
Many Excel Dashboard creators like to like to use 3D Charts in Excel presentations. However, there can be many problems when you choose to...
IMDB Top 250 Movies of All Time – Excel Dashboard Tutorial
In our last Friday Challenge, we presented a data set of the Top 250 Movies from IMDB and asked you to create a dashboard...
How-to Format Chart Axis for Thousands or Millions
Here is a great way to make your Dashboard Charts in Excel more appealing and your boss will love you and your friends will...
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...
How-to Show Decades and Highlight a Year in the Horizontal Axis
Recently in an Excel Forum, a user had data similar to this format:
Here is what he wanted to do:
How do I set the Horizontal...
