Create a Dynamic Pie Chart with Dynamic Legend in Excel which Doesn’t Display Zero Amount Categories, and Adds or Removes Categories & Updates Dynamically with the Entered Data

In the Screenshot above, this Pie Chart will adjust automatically to new values added into the Excel Sheet, adding or removing new categories as values are entered or deleted. I have something like around 80 different Categories, but each day perhaps only 10 or so get used, but they could be any 10 of the … Continue reading Create a Dynamic Pie Chart with Dynamic Legend in Excel which Doesn’t Display Zero Amount Categories, and Adds or Removes Categories & Updates Dynamically with the Entered Data

IF-THEN & IF-ISBLANK Excel Formulas for Switching Between Different Mathematical Equations Based on Different Inputs, if Present

Here is an Excel Formula for creating an Excel Form which will apply separate Math Formulas depending on the input, and if no input is entered a default text will be displayed requesting input. In this case, we'll apply one mathematical formula if the form is filled out by a Male, and a Separate mathematical … Continue reading IF-THEN & IF-ISBLANK Excel Formulas for Switching Between Different Mathematical Equations Based on Different Inputs, if Present