I have a macro that formats all the series in a chart a certain way (i.e. marker style). There may be some series that I don't want to change. What I would like is a checkbox/listbox that pops up asking me to select which series I would like to modify. Since I would perform this on different charts, the choices for the checkbox/listbox would have to be dynamic (or specific to the selected chart). So, what I would like is:

-select chart, run macro
-macro prompts to select desired chart series
-run formatting code

Any idea on how to do this? I think it can be done, but I bet the experts can figure it out quicker than me!