Quantcast
Home Tags Challenge

Tag: Challenge

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

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

Friday Challenge – AverageIf NOT Blank or NOT Zero with Negative Values for Non-Contiguous...

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

Friday Challenge Answers – Cumulative Events Over Time

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

Friday Challenge – Creating an Excel Graph of Cumulative Events Over Time

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

Friday Challenge – AverageIf NOT Blank or NOT Zero – NOT So Easy

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

Friday Challenge – Mimic Newspaper Chart Line Style in Excel

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...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link