Creating a dynamic chart for an engineering spreadsheet

[Guest]

I need to create a dynamic chart out of an existing chart. The chart is a
line chart for actual measurements. These measurements are the data range.
The Chart shows where the data points fall within a tolerance range. The
chart and the data range are on Sheet1. The supporting calculations for the
high and low tolerances are formulas in two columns on Sheet 3. (high
tolerance formula in column A, low tolerance formula in column B). The chart
has three DATA SERIES. SERIES 1 for the nominal dimension, SERIES 2 for the
high tolerance, and SERIES 3 for the low tolerance. The charts "X" axis has
no labels, the "Y" axis are gridlines with there respective dimensions to the
left in relation to the nominal dimension, which is the center gridline. As
it stands now, the chart has supporting calculations for 1,000 rows of data.
How can I format this chart to reflect the current data that is pasted in the
data range?

Cal

 

[Don Guillett]

use a defined name such as =offset($a$1,0,0,counta($a:$a),4).
Go to these for more info

http://www.tushar-mehta.com/
http://peltiertech.com/