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...
Copy Paste vs Fill Handle Copy with Tables References in an Excel formula
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...
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...
How-to Quickly Get Excel Function Help Plus a Bonus Tip
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...
Terrible Chart Tuesday – Excel 3-D Clustered Column Chart
Welcome to another edition to Terrible Chart Tuesday. Here we see an example of what I think is a Terrible Chart that was create...
How-to Add a Rupee Symbol or a Music Note or a Chess Piece to...
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...