Linked Excel Charts

[Chrisfoote]

I am trying to create multiple reports with the same format, but differing
data for the charts. I wrote VBA in excel to hit the SQL database with my
parameters, and create my charts so I don't have to do it by hand hundreds of
times a year. Now, I'm trying to lay the reports out in Publisher 2007 and
have the charts linked to Excel (2007) so I can update the charts instead of
copying and pasting every chart when it is updated in Excel.
However, I can only paste the excel chart in as a picture (PNG) when using
'paste special' instead of pasting it with a link. I have tried turning
macro settings down in the trust center in case the Excel VBA was holding me
up, using my excel workbook in 2007 and 97-2003 compatibility mode, but I
can't seem to get a link option.
I would prefer using Publisher instead of Word, since it doesn't mess with
my chart formatting so much and is more flexible. Does anyone know how to
fix this, or if I'm going down an impossible path?

 

[Mary Sauer]

Insert, Object, Create from File, browse to your Excel file. Double-click the
Excel chart in Publisher when you want to make changes.

 

[Chrisfoote]

Mary,

That's something I had already gone through, but I wasn't able to select
just the object I need. It seems to be bringing in cells and any chart
potentially in the selection area (which I can't seem to manipulate). It
doesn't seem to matter if I re-size the linked object to try and crop the
viewing area, it just re-sizes everything. When I try to edit it, I just
enter the workbook and don't see any way to specify its selection area. So,
if I have a worksheet with 3 charts and their 3 corresponding tables, how can
I select just one chart and utilize the others in another object?

 

[Mary Sauer]

Have you tried the Insert, Object, scrolled down to Excel chart, when the chart
opens, double-click (zoom first) use this to insert your data. You probably know
more about this than I do. I am not an Excel person.

 

[Chrisfoote]

I guess the solution I've run with is close to that. Since it appears to
only take your current view, so I changed the code to create the charts in
separate chart windows. That makes the chart the only item in view of the
program, and effectively draws only the active chart window in.
I put together my report, inserting them as the linked objects, but the
problem is when it links for the updates the specification is only to the
file. So, if I update it automatically, it doesn't keep the link with the
respective chart window, it instead imports the active chart window in all 27
objects. Guess I'll have to figure out if I can do VBA for that process...
Thanks for your input