Recently, a fan asked for some help. However, when I got their file, I saw that they needed some help with basic concepts, so I thought I would share those concepts with you. Now, let me pr
In our recent Friday challenge, we were asked by Anna how can we make our popular Excel Step Chart work for data that is not date based, but time based. The use case is a medical study on s
In our recent Friday Challenge, we were tasked with creating a Stacked Bar Chart where the colors matched the products. You can check out the challenge here: Original Challenge: friday-chal
In the recent Friday Challenge: Create Pipeline Usage Chart A user wanted to create a bar chart where the values had a specific color by product and also matched represented the size of the
Facebook Twitter Pinterest WhatsApp Linkedin 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
In our recent Friday Challenge, Friday Challenge – Creating an Excel Graph of Cumulative Events Over Time where a user wanted the following: Creating a graph of cumulative events over time I
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 q
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 d
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 capab
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 questio