# Excel to automatically calculate difference in values plotted on a chart

1. ## Excel to automatically calculate difference in values plotted on a chart

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  Register To Reply

2. ## Re: Excel to automatically calculate difference in values plotted on a chart

I think you need to define your problem a little better. Your data, and therefore your chart, plots the values of two independent variables over time. A value of 0.70084 for AUD/USD can appear more than once, with multiple corresponding values of AUD/CAD. If you want the difference between the two for a specific day, you already have the exact data.

Can you say more about what analysis you want to do?

This is much different than an engineering or math chart that is a function, where you can do a mathematical interpolation; you are dealing with fairly volatile empirical data.  Register To Reply