Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Newfoundland
    Posts
    41
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Is there a way in Excel to fill rectangles from 0 to each XY intersection point?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The rectangles would overlap. How would you want to handle that?

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Newfoundland
    Posts
    41
    Thanks
    4
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='776484' date='22-May-2009 15:58']The rectangles would overlap. How would you want to handle that?[/quote]

    I've manually drawn in the fill areas on the attached file. Only the incremental NPV would be displayed as the fill area.
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I don't know how to do this in an XY scatter chart.

    The attached workbook was created from Funchrt5.xls by Stephen Bullen, available from Office Automation Ltd. - Stephen Bullen's Excel Page.

    It uses named ranges to define the data for an area chart.
    Attached Files Attached Files

  5. #5
    Lounger
    Join Date
    Jan 2001
    Location
    Newfoundland
    Posts
    41
    Thanks
    4
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='776902' date='25-May-2009 19:03']I don't know how to do this in an XY scatter chart.

    The attached workbook was created from Funchrt5.xls by Stephen Bullen, available from Office Automation Ltd. - Stephen Bullen's Excel Page.

    It uses named ranges to define the data for an area chart.[/quote]

    This chart does exactly what I was looking for. Thank you for the resource link.

Posting Permissions

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