How-To

Many users use Trend Lines in Excel charts and graphs.  They may also be used in Company Dashboards, but to you can make your...

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...

Here is a real quick tip that you may want to learn when using Excel.  This tutorial will help you apply this technique to...

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...

Have you ever wondered which cells have actual values entered and which ones are calculated formulas in your Excel spreadsheet?  Perhaps you are auditing...

As you build your Microsoft Excel dashboards, you may want to highlight your data points that exceed your Key Performance Indicators (KPIs) as well...

In our previous posts we discussed how to build your dynamic Excel dashboard template charts by using an Offset formula and named ranges/formulas.  Then...

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...

Have you ever made a great chart for your Excel Dashboard and you wanted to reuse it for another set of data?  Perhaps you...

Last week a user in the Mr. Excel Forum wanted to know how to make a vertical line chart where the horizontal categories are...