Changing chart plot formulae automatically
 

I have a chart with its base data all neatly placed alongside in ten
rows. I hoped to be able to make more charts with slightly different
data by copying the whole block, assuming the formulae would alter
automatically. Which the data cells do, but not the plot formulae which
are locked by irremovable '$s'.

What's the solution ? Am I doomed to disappointment?



*** Sent via Developersdex http://www.developersdex.com ***