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
EXPLORE THE LIBRARY
Excel Dashboard Templates Home
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
Axis Formating
Problems with an Excel Dashboard Goal Chart
Troubleshooting why an Excel Dashboard Thermometer Chart was displaying the wrong values and how to fix the problem when building your own company goal graphs in Excel.
Area Chart
USA Today Charts Part 2 – Excel Area Chart with Line and Area Highlights
Use Excel to recreate a USA Today infographic
Dynamic
How-to Create a Dynamic Excel Chart that Only Displays Non-Blank Values
How-to Create a Dynamic Excel Graph that Displays Only Non-Blank Values
How-To
How-to Make a USA Today Pie Chart Graph – Replicating All Charts in USA Today Part 1
I have been traveling very frequently for business as a Salesforce.com Software Consultant, so I spend a lot of time in hotel’s and airports. So I get a lot of free newspapers like the USA
How-To
How-to Make an Excel Death Star Pie Chart
Use excel pie charts in this step-by-step chart tutorial to make your own Star Wars Death Star.
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?
Uncategorized
Website Support
Hi All, I wanted to send out a quick post to my subscribers and fans. Thank you very much for your support and I hope you have enjoyed the postings and tutorials on this site. If you have en
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
Chart
How-to Make a Beer Mug Goal Chart as an Excel Dashboard Component
Beer mug goal chart in Excel using column charts and no VBA