Challenge
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 the pipeline usage had to remain i
EXPLORE THE LIBRARY
Tag
Challenge
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 product and also matched represented the size of the
Bar Chart
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 received looked just like an Excel Bar Chart so I went with th
Excel tutorial
How-to Add a Shape to a PowerPoint Table and Make it Move and Size with the Table Cell
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 don’t want to see lots of wo
Challenge
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 cumulative events over time I
Alt-Code
How-to Add a Rupee Symbol or a Music Note or a Chess Piece to a Custom Excel Number Format
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 the dollar sign? I am using d
Averageif
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 blanks and zeros. This came from a user questio
Chart
How-to Make a Dynamic Excel Pie Chart with 4 steps in less than 4 minutes
This is an awesome guest post from our great friend Pete. He came up with this awesome technique to make a dynamic pie chart without the use of offset. THANKS PETE! Recently I saw some com
Chart
How-to Mimic a Newspaper Chart Line Style in Excel
In the recent post: Friday Challenge – Mimic Newspaper Chart Line Style in Excel we wondered if it was possible to recreate this Chart Line and Marker Style in Excel. The main issue is that
Excel tutorial
Friday Challenge Answers – The Boss Says…
I received some great responses from lots of fans. Thank you so much for all your great comments. I agree with most and my solution was very similar to Peter R.’s below. BUT, as always, P