Conditional Formatting of Pie Chart

This is an adaptation of similar code I wrote for someone else. I made a couple of changes to the basic design.

I converted the basic data in columns C:E to an Excel Table because the existing code I have looks at a table.

I changed the equation in the value column to: =IF(E47="N/A",NA(),1) - this assigns a real #N/A. Real N/As don't plot on charts.

I added data validation for the Status. You can now select the values using a drop-down list.

I have an on change event on the sheet that runs the program when you change any of the statuses.