Dear all,

Is there a way to create a list of all dataseries of a chart and output
their names to excel? I want to create a list of checkboxes dynamically for
a chart based on user selection...

Regarding pivot table, can I remove all formula/data from a pivot table by
code? For example, I want to add some metric to a pivot table based on
selection on a userform..first, I got to remove all existing data/formula
from the table. Also, do you know is it possible to change a pivot table's
name programmingly?

Thank you for your posting!