VBA for Pie Chart Where There is no Data Yet Entered - Excel

Hello,

I have a series of pie charts that overlap/look messy/get squished if there is no data yet entered.

Is there a way to display a message No Data to Display or for the pie cart to automatically remove zero values from the pie?