"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..