A newer Excel Chart creator had this question: “This is a scatter with smooth line and markers graph. What I would like to have displayed, is everything above the blue line one colour, betwe
Facebook Twitter Pinterest WhatsApp Linkedin Today I have 2 formula challenges that you may find interesting. They are both different types of allocation formulas. Challenge 1: Problem: You
Facebook Twitter Pinterest WhatsApp Linkedin Here is Pete’s answer to the recent Music Festival Schedule Challenge. In this video, see how he used Index/Match functions as well as a helper r
In our last Friday Challenge, we wanted to see if you can make a Music Festival Schedule in an Excel Chart. There were 2 questions. 1) Make a chart using Conditional Formatting and 2) Make
Here is an interesting question that I saw and I thought I would present it as the next in the series of Friday Challenges. This is a similar problem that I ran into at a recent company. Th
There is a Facebook post going around and I thought it would be a fun Friday Challenge edition. What is your answer to this this question? Then put in the formula into Excel and see what you
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
I was recently asked for assistance with this request: Hi Steve, I am trying to make a hypnogram with data that we collected over the course of a day. I want the y-axis to denote wake (W), o
In the last Friday Challenge, we were going to see if we could help a user create a chart from this data set. They were confused on what type of chart to make and how to do it. To the user
I had some great responses to the last Friday Challenge, so I didn’t want to stop the momentum with my answer to the last challenge, so I will post that next week. So here is another challe