Pie Chart - Hide legend if cell value is blank

Traditional way would be to create 2 Names in workbook (Formulas->Defined Names->Define Name) or directly calling Name Manager (Ctrl+F3) such as:

Formula:

Payer_Amounts	=FILTER(Sheet1!$E$2:$E$49,Sheet1!$D$2:$D$49<>"")

Payer_Names	=FILTER(Sheet1!$D$2:$D$49,Sheet1!$D$2:$D$49<>"")

and then use them for Series Values and Horizontal Axis Labels (write as Sheet1!Payer_Amounts and Sheet1!Payer_Names resp. - see screenshot)