Hi,

I have several charts in excel. The title of each chart is different but one thing is common that is the date mentioned on these chart's title. The date is one weeks range (08-01-08 to 08-06-08). Everytime I have to manually change the date on the chart title. Can someone tell me how to change the date range at one go for all the charts?