Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Start & End of the data series | Excel Worksheet Functions | |||
Retrieve data from all of the worksheet within the file | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
How do I reference data from one worksheet to another using combob | New Users to Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |