MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Search & Replace In Charts

Posted by Steven on May 08, 2001 9:18 AM

Is there a way to replace chart source data using the
replace function?
I have several quality performance charts that are
updated monthly a rolling 12 mos. of data)that I need
to change/advance the cell location by one column.
I am currently doing this manually to 40 charts.
I need a better way.

Posted by Mark W. on May 08, 2001 11:22 AM

Why don't you create a dynamic range and use it
in your charts?