- Dec 16, 2020
- Office Version
Is there a way to determine a Y coordinate on a Scatter with Straight Lines and Markers chart, given a specific X value? For instance, a line is drawn connecting points on said chart type. If I have a predetermined X value, is there an expression used to give the exact Y value from that line that corresponds with that given X value on the chart?