I am using Excel 2007.
I have to do a weekly chart labeled: SALES FOR WEEK #39.
Is there a way to update the chart so when I change next weeks chart, the
graph will update to : SALES FOR WEEK #40.
Right now, I have to manually go to each chart and change WEEK #39 TO WEEK
$40 and so on.
Find and replace works great where I have text but won't touch the charts.
Thanks from a newbie.