Area Chart
How-to Make a Picklist Change the Chart Type for a Dynamic Excel Dashboard
How to use a pick list to change the chart type for your excel dashboard graph
EXPLORE THE LIBRARY
Excel Dashboard category
Excel Dashboard
Soap Story Dashboard
Dial Soap Story Hotel
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.
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.
Area Chart
USA Today Charts Part 2 – Excel Area Chart with Line and Area Highlights
Use Excel to recreate a USA Today infographic
Chart
Steve Williams Caddie Earnings After Tiger Woods Split – Mini Dashboard
How much has Steve Williams earned after his split with Tiger Woods. Would he have been better off if he was still with Tiger Woods?
Axis Formating
How-to Make a Basic Gantt Chart in an Excel Chart in 7 Easy Steps
Learn the easy way on how to make a basic Gantt Chart in Excel using standard stacked bar charts. This video tutorial will show you the tips and tricks that you are missing in trying to make