Chart
How-To Create an Excel Step Chart Formula Using the Small Function
How-to create your step chart data with a formula using SMALL and VLOOKUP. Check it out in the Step-by-Step, Video Tutorial and Free Sample File Below.
EXPLORE THE LIBRARY
Excel Dashboard Templates Home
Chart Type
How-to Create a Step Chart in Excel with 3 Quick Steps
How to make an Excel Step Chart easily with a quick manual process.
Challenge
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 Step Chart in Excel However, the process of setting up
Excel tutorial
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 is what one looks like: Why use a step chart? Step char
Dashboard
Where Did My Excel 2013 Pyramid Charts Go? (Or How-to Make a Sales Pipeline Chart in Excel 2013)
Where Did My Excel 2013 Pyramid Charts Go? (Or How-to Make a Sales Pipeline Chart in Excel 2013)
Error
Find and Replace Error In An Excel Spreadsheet
Excel error caused when using find and replace to remove bullets from text copied from outlook email.
Tips and Tricks
My Excel Worksheet Only has 65000 Rows When Saving As Excel 2013 Workbook
When working between Excel 2003 and Excel 2007 or Excel 2013 formats you may run into errors. Here is an error that I recently received and how to fix it.
Challenge
Friday Challenge – Analyzing Attendance Records with Six Sigma Charts
Friday Challenge Analyzing Attendance Records with Six Sigma Charts
Challenge
Analyzing Attendance Records with Charts and Trend Line with Sparklines
Analyzing Attendance Records with Charts and Trend Line with Sparklines Friday Excel Challenge Answer.
Basketball
How-to Make a College Basketball Tournament Bracket Chart in Excel
Learn How-to Make a College Basketball Tournament Bracket Chart in Excel.
Challenge
Friday Challenge – Analyzing Attendance Records with Charts and Trend Line
For this Friday Challenge, lets see if we can help this user with their data. Read it over, but really, the last line of the request is my favorite “other ways”. This can be with one chart
Chart
How-to Fake an Excel Chart Data Table
In this tutorial, you will see an extended technique on creating a more flexible Excel Chart Data Tables.