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.
EXPLORE THE LIBRARY
Tag
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.
Challenge
Friday Challenge – Create a Percentage (%) and Value Label within 100% Stacked Chart?
Friday Excel Challenge. Analyst question in Excel. Try and recreate it in an Excel Spreadsheet. Come back on Monday to see the solution.
Chart
Multi-Column Stacked Chart – How would you do it? – How I did it.
Step-by-Step Tutorial This is my solution to this week's Excel challenge. Learn how to put category names in a stacked column chart for your Excel Dashboard
Excel Dashboard
How-to Create a Scroll Bar in Excel to Make Your Dashboard Dynamic
Learn how to use a scroll bar to dynamically change the data in the Excel dashboard chart.
Bar Chart
How-to Make a Tenant Timeline Excel Dashboard Chart
How to make an Excel dashboard chart that shows when a lease ends for a tenant.
Bar Chart
How-to Make an United States Flag Excel Chart (Happy 4th of July)
Making an Excel combo chart with a Stacked Bar chart and a XY Scatter chart that recreates the United States flag with 13 stripes and 50 stars.
Gmail
How-to Create and Copy a Table in Google Mail (Gmail) from Excel
How-to make or copy a table into Google email without losing formatting from an Excel table. Tip & trick on how to make a table with borders in Gmail from Excel