View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gordon Humphreys[_2_] Gordon Humphreys[_2_] is offline
external usenet poster
 
Posts: 12
Default 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 ***