Let say, I have two value points ( +10 and -30) plotted on a line with marker chart.
Would any of you know how to make chart display the value of Y when X is at zero, without having the zero value in data source?
Please see attached file.
For 2 points you can use the TREND function
=TREND(A7:A8,{1;2},0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks