Peter,

I will send you a working version to your hotmail address.

HTH,
Bernie
MS Excel MVP

"Peter McCaul" wrote in message
...
Hey Bernie,

Sorry for bugging you. I went back to your suggestion. After reading it
a
few times, i think i understand what you wanted me to do. Anyways, the
code
is enter into a module and the formula I've placed in cell e2 (next to the
chart). I get the #name? error when I press enter. I've retyped it a few
times, even copied and paste what you typed but to no avail. Any help is
appreciated, thanks.
"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Peter,

Visit the two links for instructions on how to use the code that I
posted
previously.

HTH,
Bernie
MS Excel MVP

"Peter McCaul" wrote in message
...
I do want a programming solution. I just didn't understand what you
had
given me. I was hoping you could explain in more detail. It will be
appreciated, thanks.