I have a graph whose Y scale is a log value and X scale is linear. However, there is an offset in the graph because of the instrument we are using. I am trying to offset that zero value by shifting the graph horizontally. I tried doing that but did not get the desired result. I will appreciate if somebody can please explain how I can horizontally shift the curve to offset at zero. Please find the columns (X and Y ) below. At present the Y axis shows zero at 0.234.
Thank you so much for your reply. Do I need to use A directly or write col(A) because I did exactly what you asked for and it gives the following error.
quote:Originally posted by YimingChen
You can use formula A - table(B, A, 0). Here table() function is to get the x value (~0.24) at y = 0 and subtract it from col(A).