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.
EXPLORE THE LIBRARY
Worksheet
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
The Tricks to Writing a Conditional Formatting Rule Formula
The best tips and tricks about wrting excel conditional formattting rules and formulas for spreadsheet dashboards.
Chart
How-to Show Excel Chart Data and Keep Chart Size when Hiding Spreadsheet Columns and Rows
video tutorial How to stoping Excel from losing data or resizing charts and graphs when you show or hide columns and rows.
Conditional Chart
Halloween Special – Spider Web, Spider and the Fly Chart
Halloween Chart - How to make a conditional radar chart that uses custom markers to have a spider chase a fly on a web graph
Copy
The Easiest Way to Copy An Excel Worksheet – (With Only One Click)
Frequently when working in Excel, I will need to copy an entire worksheet. Copying an entire worksheet is particularly helpful when you are need to copy an Excel Chart Check out that post he