I have designed a reporting system with dynamic pie charts to represent the data, which works fine. When new data is added, I have to click into each pie chart to re-tick the category and name boxes to ensure the new charts are labelled correctly.

1) Is there a way to ensure that all charts in a workbook are automatically refreshed and labelled correctly when new data is added?

2) I have been using the commonly sited macro to 'clean up active chart' to ensure that zero values are suppressed. Can this be extended to include all charts in a workbook?

Thanks