Hi
create a dynamic chart (no macros required). See:
http://www.tushar-mehta.com/excel/so...art/index.html
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html


--
Regards
Frank Kabel
Frankfurt, Germany

"Vapanda " schrieb im
Newsbeitrag ...
Here's my problem. I'm pulling data from a server daily, so the date
of
the worksheet will change. Not only will the date change, but so
will
the number of rows, due to the data that is collected. I tried to
create a macro to automate the graphing of each worksheet, but the
problem that I have ran into is that the macro is programed with the
worksheet name and the range that the worksheet used. I need to be
able to use the same macro for differently named worksheets and
different ranges. Is there a better way of doing this? Or is there
a
better way to code the macro so it doesn't recognize the name of the
worksheet or the range? I am new to vba, so it's all greek to me.

Also is there a way where I can automate this process daily. TIA.


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