Hi Charles,

I would like to stop Excel from automatically redrawing the
chart after each change to a format property and instead
wait until I have finished making ALL of my chart property
changes before redrawing the chart.

Application.ScreenUpdating=False
'Your chart code
Application.ScreenUpdating=True

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com