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
As Excel users, we may create a spreadsheet with many many many worksheets (tabs at the bottom) within the workbook. However, if you create more tabs than you can see on the bottom of the s
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
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
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
Here is a late entry 🙂 Thanks Leonid. This is an Awesome response! Leonid was responding to this recent challenge: Friday Challenge – Pipeline Usage Chart Leonid’s Solution: Essentially, th
Here is another response that I received from Don for our recent Friday Challenge: Friday Pipeline Usage Challenge Since we weren’t sure from the client if the pipeline usage had to remain i
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
I recently got a request from a subscriber that asked if I could help them create a cylinder chart. However the sample that was received looked just like an Excel Bar Chart so I went with th
As a project manager or business analyst, we are often called upon to create dashboard type views in status reports for Executives. Typically, company executives don’t want to see lots of wo