Hi,

That's an error type 13, which suggests the wrong type of value is being
placed in a variable (eg. letter where a number is required).
I have tried various things to re create you problem but can not.

If you want email your workbook to me, off newsgroup, and I will take a
look.

Cheers
Andy

rmellison wrote:
Thanks Andy, Jon Peltier's site was very useful.

I'm using the macro for multiple series with lots of data, however I get an
error at line 13 (i think) saying type mismatch. I thought it may be because
my chart has scatter and line chart data on it, so I deleted the line data
and tried again, but got the same result. I'm somewhat of a novice at VBA,
can you help any further??

Error message in VB reads 'Runtime Error: '13': Type Mismatch'


"Andy Pope" wrote:


Hi,

Jon Peltier explains various way including the picture method.
http://peltiertech.com/Excel/ChartsH...ChartData.html

Cheers
Andy

rmellison wrote:

Is there a way of copyiong a chart from one workbook to another and
'unlinking' it, such that it does not update from the original worksheet if
the original data is changed. Does it need to be copied as a picture or
similar??

Thanks in advance.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info