Challenge

In our last Friday Challenge, I proposed making a Double Lollipop Chart seen in the Wall Street Journal (WSJ).   Here is what our final chart...

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...

Movie fans are going to love this one.  Today, I present to you a full Excel Dashboard challenge. I am big movie fan.  Seen tons...

In a recent Friday Challenge, I asked our readers to transform an varying text string into dates and values to determine averages.  Well although...

Here is my answer to the most recent Friday Challenge.  Would welcome any comments below on what you think (flaws, likes, thoughts…)   In case you...

In our recent Friday Challenge, a user asked this: "This is a scatter with smooth line and markers graph. What I would like to have...

Hi Excel Fans! Today we are going to see if we can solve this question from Ajay. Ajay wrote: Can the data in chart change itself to...

Sum Excel Worksheets Technique Why haven't I known about this simple Excel technique before now? Maybe you were aware how you can easily Sum Excel Worksheets...

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...

Thanks for the submissions for the Friday Challenge. You can get the sample data and chart request here:  friday-challenge-help-new-to-excel-yoy-comparisons   Here are some other submissions: A) In the...