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
In our last Friday challenge: Friday Challenge – AverageIf NOT Blank or NOT Zero with Negative Values for Non-Contiguous Ranges I wanted to see how you could also take into account when a us
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