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...
How-to Make an Excel Chart Title Change Dynamically
Have you ever wanted to change your chart title dynamically?
Perhaps you wanted to link it to a cell value?
Did you know that it...
Tips and Tricks – Longer Legend Color Bars in Excel Charts
Here is a real quick tip that you may want to learn when using Excel. This tutorial will help you apply this technique to...
Practice Makes Perfect Excel Dashboards and Charts
I would strongly recommend that if you want to get better at building Excel Dashboard Charts and Graphs that you should try and recreate...
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...
How-to Make a Sales Pipeline Funnel Excel Chart Template
You probably have seen this type of Funnel Chart in Business Intelligence (BI) software packages and wondered how-to make this type of chart in...
Weird Excel Charts
Have you ever seen a chart or graph like this in Excel?
I created this chart using Excel the other day.
It IS one combined chart...
Date and Time Series Issues in Excel Charts
Many users think they are getting an axis error when they say that their column or line charts are showing every date between data...
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 Easily Paste a Defined Name in Chart Dialog Box
As you are learning to use Excel to develop your Executive Dashboard Templates, you will quickly learn that Defining Names are your friend.
Defined names...
