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
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
In a recent Friday Challenge, you were tasked with creating a formula that would work out for a non-contiguous (not connected) range that ignored Zero and Ignored Blanks. But, what we didn
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
Here is a Friday Challenge that a lot of Excel users may run into. Essentially, you are given a date and incident type that occurred on that date. However, the user wants to take those colu
As an Excel dashboard engineer you will often need to create complex calculations for your charts, tables and displays. So today’s challenge is one that was sent in by a reader from another
Hi All, Here is a fun challenge that I thought you might like. I saw this chart in the Denver Post and I wondered how we could recreate it in Excel. I have posted the data below and I will
I received some great responses from lots of fans. Thank you so much for all your great comments. I agree with most and my solution was very similar to Peter R.’s below. BUT, as always, P
Here is the scenario that thrills Excel data analysts and sends chills down most employee’s spines: Thursday afternoon: Your department sent out an Excel spreadsheet report on your companies