+ Reply to Thread
Results 1 to 3 of 3

chart with two y-axis

  1. #1
    Registered User
    Join Date
    08-25-2009
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    chart with two y-axis

    i am trying to design a chart with 3 axis (2 yaxis and a xaxis), where if you know the values on two of the axis you can get the values of the third.

    i have attached my spreadsheet as well as a picture showing what i would like chart to look like.

    for example, (see attached pic) i would like to be able to do this... i know Q=0.400, So= 0.100, and DEPTH= 0.100
    and i want to be able to read off the other axis that WIDTH = 2.000m

    i am having trouble trying getting the two y axis to correspond values.

    sorry for the confusing description and thanks for help in advance

    DESIGN CHART.JPEG

    gutter design chart.xlsx
    Last edited by byron_7; 08-25-2009 at 03:53 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: chart with two y-axis

    I assume at some point the relationship must get more complex as current Width is x2 the depth.

    Anway you can calculate the values using some simple maths and INDEX and MATCH functions to get the known values nearest to the inputted values.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-25-2009
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: chart with two y-axis

    yeah the maths does more complex depending on the geometry of the setup.

    thanks for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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