+ 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
    149

    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
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    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.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 08-31-2018, 07:16 PM
  2. [SOLVED] Cells values automatically to be plotted in graph
    By thilag in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-28-2015, 03:31 PM
  3. [SOLVED] Excel formula to calculate the difference of 2 values in hours
    By michael1982 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2015, 07:37 AM
  4. Excel Chart that combines a sectional bar and has a plotted point
    By JJV191 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-20-2014, 08:21 PM
  5. Replies: 3
    Last Post: 11-02-2011, 10:01 AM
  6. Replies: 2
    Last Post: 02-03-2010, 02:59 PM
  7. Need to calculate the difference between different pairs of values
    By Ilford in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2008, 11:58 AM

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