No need for VBA. See
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I have several graphs that shows the past 30 sets of data. Every couple
days I add new data to the database and I an trying to write a program
that will automatically change the source data range to show the latest
30 sets of data. I have tried a lot of things but can't get it right.
Anyone have ideas on how they would do this?


--
kola5567
------------------------------------------------------------------------
kola5567's Profile: http://www.excelforum.com/member.php...o&userid=24614
View this thread: http://www.excelforum.com/showthread...hreadid=399071