Creating a data series using another worksheet?
 

Hi all, does anyone know how to use the formula sequence of one
worksheet to generate a data series in another?

Worksheet #1 has a rather complex sequence of generating an output X
from inputs A, B and C.

Worksheet #2 has a long list of possible values for A in col.A. With B
and C remaining fixed in Worksheet #1, how do I use Worksheet #1 to
automatically generate corresponding X values, and have Excel post them
in Worksheet #2's col. B alongside the corresponding A values already
there?

Objective is to, based on the flow of Worksheet #1, produce a graph of
X for varying values of A.

Thanks,
Bob

Creating a data series using another worksheet?
 

Hi, Bob-

On Sheet2 in cell B1, you could use the following syntax to generate X

=A1+Sheet1!B1+Sheet1!C1

(Of course, I don't know how you're calculating X, but you get the idea
that you need to name the sheets in your calculation)

Then your values will be in adjacent columns for creating the chart.

Is that what you're looking for?

-Ryan

Bob wrote:
Hi all, does anyone know how to use the formula sequence of one
worksheet to generate a data series in another?

Worksheet #1 has a rather complex sequence of generating an output X
from inputs A, B and C.

Worksheet #2 has a long list of possible values for A in col.A. With B
and C remaining fixed in Worksheet #1, how do I use Worksheet #1 to
automatically generate corresponding X values, and have Excel post them
in Worksheet #2's col. B alongside the corresponding A values already
there?

Objective is to, based on the flow of Worksheet #1, produce a graph of
X for varying values of A.

Thanks,
Bob