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.
Thanks.
mqarep@yahoo.com
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?
