Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Dec 2002
    Location
    San Francisco, California, USA
    Posts
    54
    Thanks
    6
    Thanked 1 Time in 1 Post

    animated dynamic treasury yield curve (2003)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    I want to create an animated dynamic treasury yield curve. Please see:
    http://www.stockcharts.com/charts/YieldCurve.html
    Click on the animate button.
    Attached please find the data.
    Is this possible in Excel?
    Thanks. Larry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: animated dynamic treasury yield curve (2003)

    See the attached version.

    Some relevant information is cleverly hidden behind the chart. You can move the chart to see the information.
    Do not edit those cells needlessly - the chart may stop working correctly.
    The chart uses several dynamic named ranges defined in Insert | Name | Define.
    The named ranges depend on the value of cell O2, which is linked to the scroll bar.
    If you change the value of O2, the thumb on the scroll bar moves and the chart changes.
    If you scroll the scroll bar, the value of O2 and the chart change.
    The Animate button changes O2 from its minimum value to its maximum value, causing the chart to look as if it's animated.
    You'll need to enable macros if you want to click the button.

  3. #3
    Star Lounger
    Join Date
    Dec 2002
    Location
    San Francisco, California, USA
    Posts
    54
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: animated dynamic treasury yield curve (2003)

    Hans,

    Incredible. I didn

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: animated dynamic treasury yield curve (2003)

    You could animate the two charts simultaneously - that's relatively easy. But I think it would be difficult to make it work exactly like the website, where you can drag across the S&P chart.

Posting Permissions

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