I have a table with two columns. One is actual length (La), the other is given length (Lg). I want to plot a graph with '% difference in length' vs. 'given length (Lg)' without adding column for '% difference in length'.
The equation for % difference = [La-Lg]/Lg
Can I write a macro which counts the % difference from the given data and plot it vs. Lg without the % diff. column? I use this plot as a check for any errors, so I don't need to save it.
Is it possible, please help? I am pretty new at VBA. I can give more details in needed. Thanks.
The equation for % difference = [La-Lg]/Lg
Can I write a macro which counts the % difference from the given data and plot it vs. Lg without the % diff. column? I use this plot as a check for any errors, so I don't need to save it.
Is it possible, please help? I am pretty new at VBA. I can give more details in needed. Thanks.
