Alex -

It is possible to write defined formulas that compute various values,
then plot using these formulas, but I advise against it. Do the
calculations in the worksheet, and plot the range with the calculations.
Columns are cheaper than your sanity.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


alex wrote:

hello,

perhaps anybody knows how to do this:

1. i have few rows of data. in the last column there is a formula that
calculates some value for the specific row based on values in different
columns of this row and one extra value which is located somewhere and is the
same for all rows.

2. then there is a cell with total of the last column.

i want to build a chart that will have as

Y - the total cell (2.) value
X - will take the value of the extra cell and change it in a range of
plus/minus 20
for example

and chart a graph of this.

thank you,

Alex.