How to create a live chart

I want to know how to create a live chart on Excel from a set of datas which
will change on adaily basis.

"Debraj Mitra" wrote:

> I want to know how to create a live chart on Excel from a set of datas which
> will change on adaily basis.

I did a little bit of cheating
I made two sub
one create chart and the other delete chart
every time I create chart first I delete it
I put a timer (or you can check if there are new data) and after 1 min it
call create sub
I don't know better solution..