Step 7: In Formulas Tab, Click Name Manager; In Name Manager Dialog Box Click New. In New Name Dialog Box Type Name as “ShowChart” & Refers to as “=If(Sheet2!$C$4="Chart",Chart,DataRange)”, then Close.