Pipeline Challenge Matching Stacked Bar Chart Colors to Products without VBA
In our recent Friday Challenge, we were tasked with creating a Stacked Bar Chart where the colors matched the products. You can check out...
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...
How-to Add a Shape to a PowerPoint Table and Make it Move and Size...
As a project manager or business analyst, we are often called upon to create dashboard type views in status reports for Executives.
Typically, company executives...
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...
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...
How-to AverageIf Excluding Zeros and Blanks for Non-Contiguous Ranges in Excel
In our last Friday Challenge, I asked you figure out a way to calculate an average for a non-contiguous (non-adjacent) range that will exclude...