Tag: Excel

Here is a Friday Challenge that a lot of Excel users may run into. Essentially, you are given a date and incident type that occurred...

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

Welcome to another edition to Terrible Chart Tuesday.  Here we see an example of what I think is a Terrible Chart that was create...

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

With all the new affordable touch screen computers out there, you may have purchased one.  However, if you are like me, you may have...

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

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

This is an awesome guest post from our great friend Pete.  He came up with this awesome technique to make a dynamic pie chart...

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

Hi All, Here is a fun challenge that I thought you might like.  I  saw this chart in the Denver Post and I wondered how...