Hi all,
I'm building a spreadsheet to show the correlations between two currency pairs.
I have two columns of data that I've plotted on a chart.
The first column (AUD/USD) is plotted on the primary axis with the second (AUD/CAD) plotted on the secondary axis. I would like to find out the difference in value between the two currency pairs according to the plot against the secondary axis. I have attached an example. On the chart, I can roughly guess that a value of 0.70084 for AUD/USD is the equivalent of around 0.94565 on the secondary axis for AUD/CAD, meaning roughly a difference of 0.0001. Is there any way to get Excel to automatically calculate the difference for me to get a more precise figure?
I hope this makes sense! Thanks in advance,
Luke
Bookmarks