I have a scatter chart with power trend line. It is part of a manpower model.
I need to make this model interactive so what I have done is create a pivot
table of possible completion times that can plot up to 100 occurances. Each
product can be reviewed and is changed by the pivot table. I have been able
to do everything except change the the range so I can add the trend line. I
believe it could be done with an if statement but I can't think of how to
write it. So my orginal range is set and named for G3:G104. The product I am
looking at only has 4 occurances with times above zero, how can I reset the
range? Below is an example - Thanks for any help.

Individual
13.3
0.9
4.1
4.9
0
0
0
0
0
0
0
0
0
0
0

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200807/1

Nevermind - I will use a dynamic named range

Carrie_Loos wrote:
I have a scatter chart with power trend line. It is part of a manpower model.
I need to make this model interactive so what I have done is create a pivot
table of possible completion times that can plot up to 100 occurances. Each
product can be reviewed and is changed by the pivot table. I have been able
to do everything except change the the range so I can add the trend line. I
believe it could be done with an if statement but I can't think of how to
write it. So my orginal range is set and named for G3:G104. The product I am
looking at only has 4 occurances with times above zero, how can I reset the
range? Below is an example - Thanks for any help.

Individual
13.3
0.9
4.1
4.9
0
0
0
0
0
0
0
0
0
0
0

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200808/1