View Single Post
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Robert M. Franz (RMF) Robert M. Franz (RMF) is offline
external usenet poster
 
Posts: 1,741
Default Formatting Graphs imported from Excel

Hi Sabrine

SabrineV wrote:
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
--
/"\ ASCII Ribbon Campaign | MS
\ / | MVP
X Against HTML | for
/ \ in e-mail & news | Word