automating chart generation from excel spreadsheet

[teml]

Hello,

I have data in excel that needs to be generated into graphs. Severa
hundred graphs need to made from the available data so I would like th
process to be automated so that I do not need to manually make th
graph with each different set of data.

The graphs then need to be exported into a word document.

Is there a way to automate the graph making process without using VB
code?

Also, is there a way to link the graphs in the word document so tha
they automatically get updated when the data in the excel spreadshee
gets updated?

Thank you in advance for your help.

Linda T

 

[Arvi Laanemets]

Hi

This linking into Word pat confuses me a bit, but when all graphs are
similar (data ranges of same dimension, same chart types etc.), then in such
occassions I use report sheet, where I can select some identifier for data
set, and according table is generated, using formulas (p.e. VLOOKUP
functions). When you have a graph designed, based on this table, then this
graph is changed automatically too.

Are you sure you need to link graphs into Word. Maybe images will do?