HELP! Copy a Data Series to Another Graph?

[phil6666]

Hi-

I'm using Excel 2002 and I've got a lot of graphs, all of which are
based on a common spreadsheet and all are VERY similar.

When I add a new data series to one graph, it would be wonderful if
there was a simple way to copy this data series to the other graphs.

Can it be done?

(Now I add the new line to the first graph. Then I copy the X-values
from the first graph, open the second graph & paste, re-open the first
graph and copy the Y-values, re-open the second graph & paste, third
graph, fourth graph, etc., etc., etc.......)

 

[Don Guillett]

Just make the series refer to a defined name range that is automatically
adjusted when you add or subtract a line.

insert>name>define>name it myrange (or whatever)>in the refers to box use an
offset formula such as
=offset($a$1,0,0,counta($a:$a),6)
then in your series =joeblow.xls!myrange

 

[phil6666]

I'm not a total newbie, but this is a bit over my head...

I see something about "OFFSET worksheet function" in EXCEL help, but
nothing about an offset formula.


Here's the data series that I want to copy to lots of other graphs---

NAME: ='Data by Mon'!$A$184
X Values: ='Data by Mon'!$D$97:$FF$97
Y Values: ='Data by Mon'!$D$184:$FF$184

Would you show me how to do it?

thnx!

 

[Don Guillett]

offset worksheet function and offset function are sort of interchangeable.

If necessary,send, to my address below, a small workbook and I will look at
it.