Andy, It worked great. I copied your new code and pasted and run the
macro again....

But, still my goal is not to touch the chart at all. Can we also set so
that the marco would run automatically.....
If there is no other way, then I can live with whatever I have so
far...

but another thing is, everytime I run the marcos, text size, color,
etc... changes. Is there a permanent fix?


---
Message posted from http://www.ExcelForum.com/