Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
SabrineV SabrineV is offline
external usenet poster
 
Posts: 2
Default Formatting Graphs imported from Excel

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.
  #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
  #3   Report Post  
Posted to microsoft.public.word.docmanagement
SabrineV SabrineV is offline
external usenet poster
 
Posts: 2
Default Formatting Graphs imported from Excel

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

"Robert M. Franz (RMF)" wrote:

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

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem: excel graphs in word Smurfette Microsoft Word Help 1 May 8th 06 02:28 PM
Excel Formatting in Mail Merge dpahlow@nwtc Mailmerge 1 July 29th 05 06:25 PM
formatting numbers mail merged into Word table from an Excel Works Jeannie McQuaid Tables 1 July 27th 05 10:06 PM
Formatting zip code in mail merge from Excel to Word Zip code help Microsoft Word Help 1 February 10th 05 02:50 AM
formatting links from excel into word (extra line feeds) JGT Microsoft Word Help 1 December 9th 04 12:01 PM


All times are GMT +1. The time now is 06:18 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"