Here's an example. Put T values in A2:A12, V2 values in B2:B12, and V1
values in C2:C12 (B1 and C1 are reserved for labels). Press Ctrl-F3 to
open the Define Names dialog. Enter a name like DeltaV in the name box,
type an equals sign in the Refers To box, select the range containing
V2, then type a minus sign, then select the range containing V1, and
press Add. The refers To box contains the formula:
=Sheet1!$B$2:$B$12-Sheet1!$C$2:$C$12
Now use the chart wizard to generate a chart. In Step 2 of the Wizard,
Chart Source Data, clear the Data Range box on the Data Range tab, then
click on the Series tab. Click the Add button, type a name in the Name
box, type the range name in the Values box, referenced with the sheet name:
=Sheet1!DeltaV
and select the range containing the T values in the X Values or
Categories box. When you exit the Wizard, the chart should plot V2-V1
vs. T, without putting any formulas in the worksheet.
While this seems like a nice capability, I find it more robust to use
the sheet for this, and plot the cells.
- Jon
