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.