If your graph shows $ while data is showing £ you've probably entered an customized format in the graph. what happens if you remove any customized format from the graph and just tick the box for "link to Source". If done correctly Excel should inherit the format setting from the source.