Challenge
Change Chart from Amount to Percent using a Drop Down List
See how you can make a picklist or dropdown list change the number format of chart from an amount to a percentage.
EXPLORE THE LIBRARY
Tag
Challenge
Top Movies – Excel Dashboard – Brian’s Friday Challenge Entry
Friday challenge entry for the Top 250 Movies from IMDB in an Excel Dashboard
Challenge
Excel Dashboard of the Top 250 Movies – Don’s Friday Challenge Entry
Excel Dashboard Template of Top 250 Movies on IMDB
Dashboard
IMDB Top 250 Movies of All Time – Excel Dashboard Tutorial
In our last Friday Challenge, we presented a data set of the Top 250 Movies from IMDB and asked you to create a dashboard from that data set. Pete put together an amazing dashboard and here
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.
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
Chart
How-to Easily Create a Stacked Clustered Column Chart in Excel
Easiest way to make either a Clustered Stacked Column Chart in Excel or a Clustered Stacked Bar Chart in Excel spreadsheet