# Challenge

### How-to AverageIF Excluding Zeros Across Excel Worksheet Tabs

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

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

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

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

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

### Leonid’s Friday Challenge Answer – Pipeline Usage Stacked Bar Chart

Here is a late entry :) Thanks Leonid.  This is an Awesome response! Leonid was responding to this recent challenge:  Friday Challenge – Pipeline Usage...

### Pipeline Usage Chart – Don’s Answer

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

### Match Product Chart Colors to Excel Spreadsheet Cells – Pete’s VBA Solution

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

### Friday Challenge – Pipeline Usage Chart

I recently got a request from a subscriber that asked if I could help them create a cylinder chart. However the sample that was...

### Challenge Answer – Negative AverageIf for Non-Continuous Range

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...
Want to Receive the Next Post?