Copy chart from one workbook to another including names (name manager)

[LLPlates]

Hi, Have created a chart in a workbook that I would like to copy to another workbook.

As soon as I close the work book it is copied from I get mismatched or no data.

Have followed and redirected the name formulae in the worksheet but to no avail.

Does anyone have any ideas?

Appreciate the help.

LLPlates

 

[NdNoviceHlp]

Care to share how U are copying the chart to another wb... using VBA or "manually". It would be also good to know whether you are referring to a chart sheet or an imbedded chart? Also, do U actually need the functioning chart in the wb or would a picture of the chart suffice? HTH. Dave

 

[LLPlates]

Hi, Thank you for your reply.
I carried on with the problem and have solved it.
I was copying the sheet with move & copy into a workbook that had
the same sheets to take the information from had not realised I had hidden columns in the original.
Appreciate you taking the time to reply and sorry if time has been wasted.
All the best

 

[NdNoviceHlp]

Glad U got it sorted out. Thanks for posting your outcome. Be safe. Dave