EViews.com

At the risk of seeming somewhat obsessed with the excel add in...

It doesn't give the option to link/get charts - is there a reason for this? Are any future updates likely to incorporate this possibility?
I realise charts can be copied/link pasted in as objects, but that isn't really enough for me as I want to be able to change the (eviews link) reference for a number of such chart objects (without manually editing the reference in the formula bar).

I assume this could be done with VBA, but apart from recording macros I have very little experience of this.
Does anyone know of a solution?
Thanks.

R.

There are currently no any plans to add support for remapping linked OLE charts/graphs from within the add-in.

You'll have to write your own VBA macro to perform the mass-link change. I did a quick google search to see how you would do this. First, you'll need to get a list of the list sources in your workbook so you'll need to call Workbook.LinkSources:
https://msdn.microsoft.com/en-us/librar ... 21922.aspx

Next, you'll need to call Workbook.UpdateLink to update each link:
https://msdn.microsoft.com/en-us/librar ... 95741.aspx

Hope this helps...

Steve