Formatting Graphs imported from Excel

[SabrineV]

I'm trying to format some graphs I imported from excel into word
automatically. The thing is, there are I lot of graphs I have to adapt, and I
don't want to do them one by one. I have to change the size of the bars in
the graphs and the place of the labels. Every graphs has to have the same
adaptions.
I've tried making a standard lay-out feature, but I can't seem to copy this
lay-out to the other graphs I have to format.
Also, I've tried writing a macro, but adapting the size of the bars in the
graph is somehow impossible then.
Suggestions anyone?

Thx.

 

[Robert M. Franz (RMF)]

Hi Sabrine

I'm trying to format some graphs I imported from excel into word
automatically. The thing is, there are I lot of graphs I have to adapt, and I
don't want to do them one by one. I have to change the size of the bars in
the graphs and the place of the labels. Every graphs has to have the same
adaptions.
I've tried making a standard lay-out feature, but I can't seem to copy this
lay-out to the other graphs I have to format.
Also, I've tried writing a macro, but adapting the size of the bars in the
graph is somehow impossible then.
Suggestions anyone?

I doubt it's impossible. When you can get hold of the graph
programmatically, it should work.

OTOH -- instead of trying to change them in Word (and it's not clear to
me how exactly you are inserting the graphs there in the first place),
why not try to get them right in Excel? Either programmatically, or by
building a nice Excel template?

2cents
Robert

 

[SabrineV]

Hi Robert,

Thanks for the help. I actually just got a word document from my co-worker
with all the graphs already in there, which were imported automatically, by a
report writer, from excel.
You're right, having my colleague adapt this report writer probably is the
best thing to do.

Regards,
Sabrine