Excel

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

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

In this recent post: Friday Challenge Answers – Cumulative Events Over Time I created a formula that referenced a table.  As I created my video I...

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

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

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

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

In a recent post, I was exploring Excel AverageIF and other Average functions and I realized that I don’t know that much about the...

Welcome to another edition to Terrible Chart Tuesday.  Here we see an example of what I think is a Terrible Chart that was create...

A reader, Matt, after reading this post:   How-to Format Chart Axis for Thousands or Millions   And had the following question:   “How do you use this formula without...