You are not getting an answer because you question is unclear.

Please explain exactly what is going on even with examples.

--
Thanks,
Shane Devenshire


"Daniel" wrote:

My chart is dynamic but one problem is that after I refresh data I have to
fix width. Data/text to column/fix width/ finish.

How can I write a macro so I will automatically fix width

Or How can I change this to defaul so I don't have to fix with every time
hitting
refresh data.

Thanks for your help
Daniel