Excel

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

Titles on charts are not always necessary but when you use them, you will have many, many choices on formatting of which you may...

If you have a chart with Legends, then you should check out this tutorial. Recently when working on a solution for a fan, I noticed...

Okay, for the last challenge, Peter went above and beyond and also submitted a VBA solution to this problem.  Great job Peter! Here is how...

In our last Friday Challenge, we were investigating Step Charts.  In case you missed it, you can check it out and download the sample...

I saw this seemingly simple question from an Excel user but I spent a long time trying to figure it out without much success. Can...

In this recent post: Friday Challenge Answers – Cumulative Events Over Time I created a formula that referenced a table.  As I created my video I...

Leonid, a wonderful reader of our website, sent in a new take on my Excel Project Status Spectrum Chart.  Here is what his looks...

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

A user wanted to know how to create an Excel chart that shows when his tenant’s leases are expiring.  He wanted to put this...