What is the purpose of creating all those graphs? Do you really need
to create them all at the same time or could you just create a block
at a time?

In the past when creating large numbers of plots from the same
datablock I've found it works well to create a graph, copy a picture
of it and paste it into another sheet, shift the graph data source to
the next row, copy picture etc etc.

If you need to get a start you might try recording a macro while
creating the first graph and use that as a basis. Be warned that 4500
plots is a large number for one spreadsheet so you may not be able to
create them all in one batch.

You can contact me via email if you are really stuck and I'll try
digging out some previous code...


Tim.



"canes_26 " wrote in message
...
Greetings-

I have a spreadsheet that has roughly 4500 rows with 7 columns of
data.
Along each row I need to make a line graph that uses the values from
the seven columns in that row.

Seeing as though creating each chart one by one would take FOREVER I
was wondering if there is a way to write a program that will do this
for me?

I purchased a book called "Writing Excel Macros" by Steven Roman.
But
I am still having trouble finding anything that will help. If
someone
could help me, or direct me where to go it would be very much
appreciated.

Thank you.


---
Message posted from http://www.ExcelForum.com/