Friday Challenge – Excel Mutli-year Graph by Month

For this Friday's challenge, lets see how we can help this user visualize this data set.  Here was the Excel user's question:   "Mutli-year graph by...

How-to Make a Cool Looking 3-D Sales Funnel or 3D Sales Pipeline Chart in...

Some times these types of charts are called funnel charts or some times they are called pipeline charts.  Regardless of what you call them,...

Understanding How-to Make a Step Chart in Excel Using Index and Match Functions

Here is a quick demonstration on the technique that Peter used for his Step Charts: Learn More about the Challenge HERE   To try it yourself as...

How-To Create an Excel Step Chart Formula Using the Small Function

In our last Friday Challenge, we were investigating Step Charts.  In case you missed it, you can check it out and download the sample...

How-to Create a Step Chart in Excel with 3 Quick Steps

Here is the first and easiest answer to the challenge on posted on Friday. In case you missed it, you can check it out and...

Friday Challenge: Excel Step Chart Automation

Yesterday, I posted the a demonstration on how to make a Step Chart in Excel. You can check out that post here: How-to Easily Create a...

How-to Easily Create a Step Chart in Excel

You might be asking yourself, “What is a Step Chart?” You have probably seen one, but didn’t know that it is called a step chart. Here...

Where Did My Excel 2013 Pyramid Charts Go? (Or How-to Make a Sales Pipeline...

In a previous post I showed you how to make an Excel Sales Funnel Chart or Sales Pipeline Chart, but it is a little...

Find and Replace Error In An Excel Spreadsheet

I have just started on a new project and I ran across this error or should I say issue?  Maybe you have seen this...

My Excel Worksheet Only has 65000 Rows When Saving As Excel 2013 Workbook

So that everyone can use my Excel Charts and Dashboard Templates, I typically save my files in an Excel 97-2003 format.  There are other...