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

How can I avoid to do this?
Or
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

A macro to do this would be easy. Simply turn on macro recording, execute the
tasks you need (Text to Columns, Column Width, etc.), stop recording and save
the macro. You can then run the macro anytime you want.

--
Regards,
Fred


"Daniel" wrote in message
...
My chart is dynamic but one problem is that after I refresh data I have to
fix width everytime. ( Data/text to column/fix width/ finish).

How can I avoid to do this?
Or
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

THanks Fred
I will record a macro and run but How can I make it run automatically when
I refresh data?
Thanks again
Daniel


A macro to do this would be easy. Simply turn on macro recording, execute the
tasks you need (Text to Columns, Column Width, etc.), stop recording and save
the macro. You can then run the macro anytime you want.

--
Regards,
Fred


"Daniel" wrote in message
...
My chart is dynamic but one problem is that after I refresh data I have to
fix width everytime. ( Data/text to column/fix width/ finish).

How can I avoid to do this?
Or
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