Sorry hit the send button to early.

The help on features not available in shared workbooks states that you
can not,

Create or change charts or PivotChart reports although You can view
existing charts and reports.

The restriction means you can not change the charts formatting
properties or copy it. Values within the chart will update when the
underlying data changes.

So no you can not manually do it. But a quick test would suggest that a
macro could be used. I was able to copy the chart and paste it in
another workbook. The data was still referencing the shared book but you
can also change that as required with code.

Cheers
Andy