Chart, plotting a series at an angle

Copper Contributor

Hello everyone,

I'm having 2 problems with making a chart

Problem 1:

I'm trying to find a way how to plot series at an angle
This i how that graph should look

Screenshot_3.jpg

Only data i have to begin with is "C" ,(x(вертикално опетрећење)=0, y(чврсточа на смицање)=17) starting point of the line
and angle, (in this case the angle is 18) which determines at what angle with the line continue to x value 400

Problem 2:

I need to find the y value (чврсточа на смицање) when the plotted line series intersects major gridlines at 150, 250 and 350

Is there a way to do it by some math or adding some series to act like gridlines, would be much better then too manually look on the chart and write the new values
(need to automate that process, another chart need those values)

1 Reply

@Est3tic 

See the attached sample workbook.