Daniel;

Hate to say so, but I don't understand anything of your question.

Also, what does this have to do with "Excel charts"?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Daniel" wrote:

How can I write a macro to have it refresh data and text to column/ fixed width

How can I develop this macro not for a sheet but for a work book.

Thanks
Daniel