Subtracting curves
in [Charts]
|
Prev: Time-date chart plotting
Next: Longer Tick Marks
From: A.for.Andy on 25 Jun 2008 09:14 Dear All I am looking to subtract a baseline from graphs, but I have not found a method of subtracting curves in Excel. More specifically, I am looking to compensate for machine slack during compression testing, thus the baseline will be consistent from data set to data set. A colleague has designed a fairly complicated multi sheet workbook that interpolates the data ranges before graphing, but it has it's errors and is still not perfect. The best solution I have found so far is a program called FindGraph, but I am hoping to find a solution within Excel (ie: free!). Can anybody help? Many thanks in advance Andy
From: Jon Peltier on 25 Jun 2008 12:28 Are you offsetting all points of a series by the same amount? Then just add or subtract the amount from each data value in the worksheet. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ <A.for.Andy(a)gmail.com> wrote in message news:d64870e8-6782-4614-9b56-48093dbc0f1a(a)a1g2000hsb.googlegroups.com... > Dear All > > I am looking to subtract a baseline from graphs, but I have not found > a method of subtracting curves in Excel. More specifically, I am > looking to compensate for machine slack during compression testing, > thus the baseline will be consistent from data set to data set. A > colleague has designed a fairly complicated multi sheet workbook that > interpolates the data ranges before graphing, but it has it's errors > and is still not perfect. The best solution I have found so far is a > program called FindGraph, but I am hoping to find a solution within > Excel (ie: free!). Can anybody help? > > Many thanks in advance > > Andy
From: A.for.Andy on 26 Jun 2008 03:31 On Jun 25, 5:28 pm, "Jon Peltier" <jonxlmv...(a)SPAMpeltiertech.com> wrote: > Are you offsetting all points of a series by the same amount? Then just add > or subtract the amount from each data value in the worksheet. > > - Jon > ------- > Jon Peltier, Microsoft Excel MVP > Tutorials and Custom Solutions > Peltier Technical Services, Inc. -http://PeltierTech.com > _______ > > <A.for.A...(a)gmail.com> wrote in message > > news:d64870e8-6782-4614-9b56-48093dbc0f1a(a)a1g2000hsb.googlegroups.com... > > > > > Dear All > > > I am looking to subtract a baseline from graphs, but I have not found > > a method of subtracting curves in Excel. More specifically, I am > > looking to compensate for machine slack during compression testing, > > thus the baseline will be consistent from data set to data set. A > > colleague has designed a fairly complicated multi sheet workbook that > > interpolates the data ranges before graphing, but it has it's errors > > and is still not perfect. The best solution I have found so far is a > > program called FindGraph, but I am hoping to find a solution within > > Excel (ie: free!). Can anybody help? > > > Many thanks in advance > > > Andy- Hide quoted text - > > - Show quoted text - Hi Jon Unfortunately it's not as simple as that. While the data ranges covered are the same, the data points within the ranges do not match up across the ranges, hence the interpolation calculations being done at the moment. Andy
From: Jon Peltier on 26 Jun 2008 12:42 I missed the interpolation remark. You could either fit both series to a curve (trendline) and use the fitting parameters to determine the difference, or you could do the interpolation, wither using worksheet formulas or VBA. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ <A.for.Andy(a)gmail.com> wrote in message news:c80b86eb-d9af-4fa9-a97e-14f6f370c6ad(a)y38g2000hsy.googlegroups.com... On Jun 25, 5:28 pm, "Jon Peltier" <jonxlmv...(a)SPAMpeltiertech.com> wrote: > Are you offsetting all points of a series by the same amount? Then just > add > or subtract the amount from each data value in the worksheet. > > - Jon > ------- > Jon Peltier, Microsoft Excel MVP > Tutorials and Custom Solutions > Peltier Technical Services, Inc. -http://PeltierTech.com > _______ > > <A.for.A...(a)gmail.com> wrote in message > > news:d64870e8-6782-4614-9b56-48093dbc0f1a(a)a1g2000hsb.googlegroups.com... > > > > > Dear All > > > I am looking to subtract a baseline from graphs, but I have not found > > a method of subtracting curves in Excel. More specifically, I am > > looking to compensate for machine slack during compression testing, > > thus the baseline will be consistent from data set to data set. A > > colleague has designed a fairly complicated multi sheet workbook that > > interpolates the data ranges before graphing, but it has it's errors > > and is still not perfect. The best solution I have found so far is a > > program called FindGraph, but I am hoping to find a solution within > > Excel (ie: free!). Can anybody help? > > > Many thanks in advance > > > Andy- Hide quoted text - > > - Show quoted text - Hi Jon Unfortunately it's not as simple as that. While the data ranges covered are the same, the data points within the ranges do not match up across the ranges, hence the interpolation calculations being done at the moment. Andy
From: Del Cotter on 26 Jun 2008 13:04
On Thu, 26 Jun 2008, in microsoft.public.excel.charting, A.for.Andy(a)gmail.com said: >Unfortunately it's not as simple as that. While the data ranges >covered are the same, the data points within the ranges do not match >up across the ranges, hence the interpolation calculations being done >at the moment. The important thing to realise is that this is not an Excel charting question. Interpolation calculations are a matter of algebra. All Excel Chart does is display points you give it via spreadsheet cells, and join them up with lines. Any calculations you do would be the same whether you were charting the result or not, so the posters here can't help you except in so far as they may by chance know something about excel functions. You're really better off asking in microsoft.public.excel.worksheet.functions where the real function experts are. -- Del Cotter NB Personal replies to this post will send email to del(a)branta.demon.co.uk, which goes to a spam folder-- please send your email to del3 instead. |