Quantcast

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