Challenge
Friday Challenge – Allocation Formulas
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
EXPLORE THE LIBRARY
Tag
Challenge
Don’s Macro Enabled Friday Challenge Answer – Music Festival Schedule Excel Chart
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
Bar Chart
Friday Challenge – Create a Chart to Display a Music Festival Schedule
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
Challenge
Friday Challenge: What is your answer vs. Excel?
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
Excel tutorial
Better Formulas for Pipeline Matching Stacked Bar Chart Colors to Products without VBA Solution
Hands off to Leonid 🙂 for this awesome solution with much Much BETTER formulas for a recent Friday Challenge. Here was the original Challenge: friday-challenge-pipeline-usage-chart Here was
Challenge
How-to Create a Time Data Series Step Chart in Excel
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
Challenge
Friday Challenge – Step Chart for an Excel Time Series
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
Challenge
Petes Stumped Chart Challenge Answer – Pivot Chart with Slicers
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
Area Chart
Pipeline Challenge Matching Stacked Bar Chart Colors to Products without VBA
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
Challenge
Friday Challenge – Stumped on How to Display Data in an Excel Chart
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