+ Reply to Thread
Results 1 to 2 of 2

Excel to automatically calculate difference in values plotted on a chart

  1. #1
    Forum Contributor
    Join Date
    08-20-2009
    Location
    Plymouth, England
    MS-Off Ver
    Excel 2013
    Posts
    141

    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
    Attached Files Attached Files

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    15,207

    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.
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1