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.
EXPLORE THE LIBRARY
/category/video-tutorial/page/12/
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.
Challenge
Friday Challenge Answer Part 1: Splitting Up Email Address Text
How-to Splitting Up Email Address Text with Excel Formulas using text to columns
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.
Connect Line Data Points
How-to Show Gaps in a Line Chart When Using the Excel NA() Function
Learn how to have gaps in a line chart when using the NA function in an Excel Formula
Chart
How-to Eliminate Statistical Outliers in an Excel Line Chart
Learn how to create a dynamic Excel chart where you can hide outliers in a Line chart or Line graph. Free Excel Template download file
100% Stacked Column Chart
Friday Challenge Answer – Create a Percentage (%) and Value Label within 100% Stacked Chart?
Friday Excel Challenge to Learn how to add percentages and value labels to the data series in an Excel 100% Stacked Column Chart or 100% Stacked Bar Chart.