Excel Dashboard Templates

In a recent post, I was exploring Excel AverageIF and other Average functions and I realized that I don’t know that much about the AverageA Excel function.   So I thought I would share how I...

Welcome to another edition to Terrible Chart Tuesday.  Here we see an example of what I think is a Terrible Chart that was create in Excel.   What do you think?  Let me know in the...

A reader, Matt, after reading this post:   How-to Format Chart Axis for Thousands or Millions   And had the following question:   “How do you use this formula without the dollar sign? I am using different units than dollars...

With all the new affordable touch screen computers out there, you may have purchased one.  However, if you are like me, you may have large fingers and trouble using your laptop’s touch capabilities in...

In our last Friday Challenge, I asked you figure out a way to calculate an average for a non-contiguous (non-adjacent) range that will exclude blanks and zeros.   This came from a user question on a...

As an Excel dashboard engineer you will often need to create complex calculations for your charts, tables and displays. So today's challenge is one that was sent in by a reader from another of...

This is an awesome guest post from our great friend Pete.  He came up with this awesome technique to make a dynamic pie chart without the use of offset.  THANKS PETE!   Recently I saw...

In a follow-up to my recent Terrible Chart Tuesday, I wanted to show you 2 different techniques that you can use to create a chart in Excel where the line goes up instead of...

Hi All, I just got a wonderful Christmas gift from our friend Piotr in Poland. He emailed me his awesome rendering of a Christmas tree in an Excel chart. And I asked if I could share it...

In the recent post: Friday Challenge – Mimic Newspaper Chart Line Style in Excel we wondered if it was possible to recreate this Chart Line and Marker Style in Excel.  The...