Hi guys,

I dont know if this applies to excel, but it should do.

I have a software that creates many Powerpoint files that have Charts inside them, on those charts for some months many Series(Columns) are all empty, and filtering or deleting this by hand every month takes many hours.

I have searched everywhere but cannot find any information regarding a macro for this that works in Powerpoint, all I need is a macro that checks the " embedded excel tables" from each chart and deletes or filters all columns that have a 0 value.

Many Thanks