So there is a problem: I get data from the internet in table form( currency),and i want to get it into the chart form,and after refreshing-it could show the same as real forex trading platforms. And sorry for typing not in right direction, VBA close to /excel..and couldn't find any closest

and how to make data query to be refreshed only one per sheet,I mean how to make sheet independable from others