Tag: Formula
Excel Formulas: Average a Range and Ignore Zero’s (0 Value)
Excel formulas are a wonderful thing, but they may not provide all the flexibility you want when calculating information for your Executive Dashboard display. ...
How-to Hide a Zero Pie Chart Slice or Stacked Column Chart Section
Okay, we have learned lots of different techniques to build our Company Executive Dashboard using Excel, and today I will give you a taste...
How NOT to use Concatenate Function to build Dynamic Text in your Excel Dashboard...
It may seem like a weird title, but I will explain.
As you build your Excel Dashboard, you will want to use text for data...
