graph one minus graph 2

L

Liz

Hi,
I need to deduct 2 graohs from each other in excel. The sets of data used to
create the graph have different x values so I can't just deduct them from
each other and because they have been collected from a research project they
have no regularity to create a function or trendline. Is there anyway to
create this at all?
ther are more than a thousand values so this can't be done by hand.
Any help would be appreciated
 
J

Jon Peltier

It sounds like your chances of success are limited, but you could try to use
worksheet formulas or a VB routine to produce interpolated results at
various points along the two data series, then subtract the values as
needed. This is all done in the worksheet, of course.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/>
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data read from exponential graph 0
Plotting against Date (collating months) 2
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Extrapolation of x value from the trendline of a non-linear graph 1
How do I add a trend line for only half of my graph? 1
Occasional meter readings chart 0
How to paste this down? 3
Trendline Not Appearing In Chart Problem ? 0

Top