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.
EXPLORE THE LIBRARY
By
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
Conditional Chart
How-to Make a Non-Chart Excel Dashboard Chart (Heat Index)
Tutorial and video on how to make an non-chart excel chart using conditional formatting techniques, tips and tricks. A NOAA National Weather Service Heat Index
Column Chart
How-to Create a Sick Leave Excel Dashboard Chart
Learn how to use custom markers and offset formulas to create a sick leave chart for an Excel Dashboard.
Excel Dashboard
How-to Make a WSJ Excel Pie Chart with Labels Both Inside and Outside
Learn How-to Make an Excel Pie Chart with Labels where the labels are both Inside and Outside of the pie slices. This was from a Wall Street Journal infographic.
How-To
How-to Add Label Leader Lines to an Excel Pie Chart
Learn how-to create label leader lines that connect pie labels that are outside of the pie slice to the appropriate pie section. It is a simple tip and trick.
Array
Removing Array Formulas Around Your Excel Charts and Dashboards
Excel dashboard protection tip and trick using array formulas
Array
Protecting Your Excel Charts and Dashboards with Array Formulas
Using Arrays can protect you from getting reference errors when users delete or insert rows or columns in your Excel Dashboards
Chart
How-to Create Dynamic Excel Dashboards Using Picklists
Let users pick the chart data displayed in your dynamic company dashboard by using a picklist that changes the values shown in your chart.
Chart
Creating Pick Lists in Excel for your Dynamic Dashboard
using data validation to make a dynamic chart for your excel company dashboard