The easy way is to use named ranges defined by formulas - dynamic ranges:

http://support.microsoft.com/default...46&Product=xlw
XL: Using Defined Names to Automatically Update a Chart Range

If you want code:

http://support.microsoft.com/default...40&Product=xlw
XL97: How To Create a Dynamic Chart Using Visual Basic

http://support.microsoft.com/default...80&Product=xlw
XL2000: How to Use Visual Basic to Create a Dynamic Chart

http://support.microsoft.com/default...55&Product=xlw
Using Visual Basic to Create a Chart Using a Dynamic Range

--
Regards,
Tom Ogilvy


"bruce forster" wrote in message
...
Bob: IT WORKED. Thanks. I hope you will continue to be available to
answer a few more questions regarding my programming. The help I have
gotten on this site has been invaluable.

thanks.

One question I do have and will send my code later is how to make a graph
that changes when inputs change. I think it is referred to as a dynamic
chart.

Talk to you soon.