Labels in a chart

[Charles Eaves]

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.

 

[Andy Pope]

Hi

You could link the chart title to a cell.
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

 

[Charles Eaves]

Thanks.
I will give it a try.
Excellent site.

Hi

You could link the chart title to a cell.
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

 

[Charles Eaves]

Thanks Andy!!!!!
It worked like a charm.

Thanks.
I will give it a try.
Excellent site.