Look at this link. I think you will find this solution easier than using the Yahoo method.

Excel Dynamic Chart #13: Web Query Stock Percent of Target Chart - YouTube