Consulting

Results 1 to 1 of 1

Thread: Charting Scenarios

  1. #1
    VBAX Contributor
    Joined
    Nov 2007
    Posts
    144
    Location

    Charting Scenarios

    I have created a chart - attached - that is used to test various scenarios.

    Sheet (Scenario Chart) = sheet with chart and inputs
    Sheet (Test data) = the values I used to created the chart

    I have also created boundaries within this chart:

    Y axis maximum = 15.1
    Y axis minimum = 7.6

    X axis maximum = 6.5
    X axis minimum = 2.6

    My query is, even though I can move 2 independent points around the chart, how can I keep them within the boundaries.

    For example:
    If the 'Fuel Input' in increased, once it reaches 6.5, the value remains at 6.5 but the 'Net Thermal Output' is increased.

    Note: The boundary is not a straight forward 4 sided box, it actually has 2 slanted sides, just to keep things interesting.

    Any help is greatly appreciated.
    Last edited by f2e4; 07-29-2010 at 02:51 AM.

Posting Permissions

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