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
Bookmarks