Hi JulieD,
Not exactly. I have an engineering spreadsheet. When I measure parts, I
paste or import the measurement data into column "A" in Sheet1. I created a
dynamic line chart to plot this data. Within this chart I have two red grid
lines signifing the high and low tolerance of the measured data. The center
gridline is the measurements nominal dimension, or what the features
measurement is supposed to be. To have the chart work dynamically, I defined
a name for each data series ( Nominal, High Tolerance, and Low Tolerance ),
using the OFFSET and COUNTA funtions. The nominal data series comes from the
pasted of imported data in column "A". The high tolerance data series comes
from a formula in column "A" on sheet2. The low tolerance data series comes
from a formula in column "B" on sheet2. I wrote a macro for the high and low
tolerance formulas on sheet 2. After you paste data into column "A" on
sheet1, the chart will expand to reflect the new data. I then run the macro
on sheet2 for the same amount of rows that the data on sheet1 reflect. This
action will draw the red lines that represent the high and low tolerances in
the chart, and size them to reflect the added data. On Sheet1, column "B" is
a deviation from nominal formula, and column "C" is a pass or fail formula.
My problem is that I may have fifty charts on Sheet1, representing
fifty features measured. When I copy and paste the chart fifty times, the
data series columns will remain the same. Right now I have to define names
for values and labels for every chart to reflect the columns that the data is
drawn from. I then have to change the three data series formulas to reflect
the columns the data is drawn from. As you can see, this is very time
consuming. Is there a way to copy and paste the chart so the defined names
and data series can be also pasted, and to reflect the columns it is being
pasted to. Any help would be appreciated.
Thanks,
Cal
10 on that sheet .. now you want to copy & paste the