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
/tag/excel/page/24/
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?
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