Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Attached please find a Graph where i have tried to plot the future Values as a time path of the prices of Bond C & Bond Z

    It would be appreciated if you would check & amend if necessary

    regards

    Howard
    [attachment=83548:Time_Path.xlsx]
    Attached Files Attached Files

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='HowardC' post='773272' date='01-May-2009 10:35']Attached please find a Graph where i have tried to plot the future Values as a time path of the prices of Bond C & Bond Z

    It would be appreciated if you would check & amend if necessary

    regards

    Howard
    [attachment=83548:Time_Path.xlsx][/quote]
    Recommendations follow:
    • Remove the blank row between the headings and the table, it is inserting a meaningless data point in your X axis.
    • When creating the chart do NOT place a heading over the X axis labels ("T" in A1). This includes your X axis labels to be considered a data series, and applies 1 through n as the X axis labels.
    • Right clicking the axes will allow you to set the scale.
    Attached Files Attached Files
    Regards
    Don

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    [quote name='wdwells' post='773282' date='01-May-2009 16:04']Recommendations follow:
    • Remove the blank row between the headings and the table, it is inserting a meaningless data point in your X axis.
    • When creating the chart do NOT place a heading over the X axis labels ("T" in A1). This includes your X axis labels to be considered a data series, and applies 1 through n as the X axis labels.
    • Right clicking the axes will allow you to set the scale.
    [/quote]

    Hi Don

    Thanks for the help

    Regards

    Howard

Posting Permissions

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