Help coding for 10 different X Axis
I have a table, “control 1,” for the manual input of mid asset prices for the x axis, eg 12600 for the £/$.
In another table called "Legs 1-10 P/L,” I have 10 columns of x axis data (10 columns with 100 rows above and 100 below the mid price in increments of +/-25), located in columns L2 to U2, that is sourced from the real data in columns A to J).
The offset code for the first Leg in Col L is:
IFERROR(OFFSET($A$2, ROW(cell)− ROW($L$2), MATCH('Control 2 - Individual / Strategies'::$B$2, $A$1:$K$1,0) − 1), "")
I want to be able to manually enter the mid asset prices in B2, C2, D2 etc to K2 in “Control 1” and have the choice of which x axis data to display for the charts x axis (vertical right display) from "Legs 1-10 P/L.”
Eg Legs 1, 2 and 3 are £/$ trades and the mid asset price value at the time of trade = 12600 (ranging from 10100 to 15100). I would like to be able to use the offset formulas (as I have for plotting other x and y axis data), so that the chart will show the asset prices from 10100 to 15100 below the x axis.
How can I achieve this?
Cheers!
MacBook Pro 15″, macOS 12.3