Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem: excel graphs in word | Microsoft Word Help | |||
Excel Formatting in Mail Merge | Mailmerge | |||
formatting numbers mail merged into Word table from an Excel Works | Tables | |||
Formatting zip code in mail merge from Excel to Word | Microsoft Word Help | |||
formatting links from excel into word (extra line feeds) | Microsoft Word Help |