I'm trying to write a macro which will create a line graph and have included
the following line:

ActiveChart.SetSourceData
Source:=Sheets("Data").Range("DynDates,DynBrandVol ,DynCatVol"), _
PlotBy:=xlColumns

where DynDates, DynBrandVol and DynCatVol are dynamic ranges defined using
the offset function. This throws up an error message, and I seem to remember
seeing something about not being able to use dynamic ranges in this way. Am
I right - and what's the way round it?

Thanks for any help.

Colin Macleod