hello,

perhaps anybody knows how to do this:

1. i have few rows of data. in the last column there is a formula (same in
all rows)that calculates some value for the specific row based on values in
different columns of this row and one extra value which is located in
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.