Excel Dashboard Templates

Excel formulas are a wonderful thing, but they may not provide all the flexibility you want when calculating information for your Executive Dashboard display.  Sometimes you need to make your own formulas when Excel...

Many users think they are getting an axis error when they say that their column or line charts are showing every date between data points, but all they want to show is the dates...

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

As you build your Microsoft Excel dashboards, you may want to highlight your data points that exceed your Key Performance Indicators (KPIs) as well as those data metrics that do not meet your KPI’s. ...

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 in our last post we showed you how-to quickly paste...

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 are great in saving time, and changing ranges in formulas...

Have you ever made a great chart for your Excel Dashboard and you wanted to reuse it for another set of data?  Perhaps you want to recreate the chart for a new year or...

Last week a user in the Mr. Excel Forum wanted to know how to make a vertical line chart where the horizontal categories are displayed vertically and then also wanted the vertical axis numbers...

Here is a great way to make your Dashboard Charts in Excel more appealing and your boss will love you and your friends will envy your Extreme Spreadsheet knowledge. When you have really large numbers...

In the Mr. Excel forum, a user was having problems printing a repeating row or repeating column for his Excel report.  Seems they couldn’t select any rows or columns when trying to create the...