Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
graph one minus graph 2
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
graph one minus graph 2
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...00906ACNJ.html _______ "Liz" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
How do I plot multiple series on one graph? - test-graph.xls (0/1) | Charts and Charting in Excel | |||
Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
Creating a graph similar to a stacked column graph | Charts and Charting in Excel | |||
Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel |