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
Tag
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)
Basketball
How-to Make a College Basketball Tournament Bracket Chart in Excel
Learn How-to Make a College Basketball Tournament Bracket Chart in Excel.
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.
Bar Chart
SEO Performance Charts – Don’s Solutions
See how Don created 3 different versions of charts for a recent Friday Challenge for SEO Performance bar chart, bubble chart and stacked column chart.
Challenge
How-to Make a Dynamic Hotel Ballroom Occupancy Chart
See how to create a hotel occupancy chart using advanced date functions, countif formulas and conditional formatting. Also included is finding out how many days are in any month and if any d
Axis Formating
How-to Make a Pass Fail Chart in Excel
Step-by-Step Tutorial on making a visual representation of Pass / Fail data in an Excel Chart.
Email
How-to Split Up Email Address Text with Excel Formulas – Part 2
Learn how to create dynamic Excel formulas using text functions to breakup or split an email address into First Name, Middle Name, Last Name and Domain Name.
Concatenate
How-to Concatenate Excel Column or Row Data Using Google Docs
How to use Google Docs to Concatenate a range in Excel without the using a formula. Best for lots of data to concatenate or when you want to do it quickly.
Bubble Chart
Dynamically Change Excel Bubble Chart Colors
This tutorial will show you how to conditionally format bubble colors in an Excel chart using the NA() function.