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...
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...
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...
Friday Challenge – Analyzing Attendance Records with Six Sigma Charts
The following is a guest post from Pete on his answer to the most recent Friday Challenge.
Pete applied his knowledge of Six Sigma to...
How-to Make a College Basketball Tournament Bracket Chart in Excel
Well it is March and that means that it is Madness in college basketball. And with that madness comes the bracket challenges in every...
How-to Fake an Excel Chart Data Table
Fake an Excel Chart Data Table
Yesterday, I showed you how you can use the Horizontal Axis option of “Multi-level Category Labels” to create a...
How-to Show Text in an Excel Chart Data Table (Part 1)
Yesterday, I showed you how you can use the new label options in Excel 2013 to help Kevin with his engineering chart. But we...