Thanks I will reply to the charting group now.

I do have the code in chart_activate, howver this only works when yo
first click the chart, not when you use any of the dropdowns on
pivotchart. Using the dropdowns removes your formatting so I need t
re-apply the macro whenever the dropdowns are used but cant work ou
where to call the macro from in order to do this.

Thank

--
Message posted from http://www.ExcelForum.com