In message
at 21:13:51 on Thu, 30 Aug 2007, Jon Peltier
wrote
Make your life easier. The dynamic range for YValues is good, so is that for
XValues, derived smoothly from YValues. Use the same to give you a
reasonable Ave1, which has to start on the same point as YValues in order to
plot correctly on the line chart:

Ave1=
OFFSET('Basic Range'!YValues,0,1)

Now plot both YValues and Ave1 using XValues for X.

- Jon

Wow that is superb and very clever

Many thanks for your help
--
Mike News