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...
Friday Challenge Answers – The Boss Says…
I received some great responses from lots of fans. Thank you so much for all your great comments. I agree with most and my...
Free Dashboard Template Download – BMI Weight Tracker
In this ever expanding universe, so is my belt. I need to drop more than a few pounds.
Now I can use an Excel Dashboard...
How-to Make an Excel Vertical Likert Line Chart with Categories
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel. The person...
How-to Format Trend Line Color in Excel Dynamically
Many users use Trend Lines in Excel charts and graphs. They may also be used in Company Dashboards, but to you can make your...
How-to Make a Conditional Column Chart in Excel – REDO
·
In a previous post, I showed you how to make a Conditional Column Chart for your Executive Dashboard Templates, but I had 3...
Find the Last Row or Last Column for Dynamic Excel Dashboards
In a previous post “This is the Bomb: or How I came to love the Offset function” I showed you all about the Offset...
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 Close the Gaps Between Chart Series in an Excel Stacked Clustered Column Chart
Many users like to create a chart that Excel doesn’t have as a chart type. It is a combination of a clustered column and...