Ok, just post back to this thread if you need further assistance.

Biff

"pdgood" wrote in
message ...

You are right, the first comment is an error on my part. I moved the
entry cells and forgot to update this question. (I've been working on
how to word it for several days). I can make them be any cell, so I'll
go with your example.

Yes, the min value entered is always keyed to the vertical axis no
matter if it's the height or width and the max value to the
horizontal.

You are right, A1 is not actually used since the value of 0 would never
be applicable in this chart. I added it because I thought it would help
clarify the numbering system better (rather than beginning on .25) ,
but I see now that I just muddied my explanation rather than cleared it
up. Glad you were able to see through this.

I'm anxious to try the formula you suggest and will as soon as I return
to work tomorrow. If I struggle I will upload the file as you suggest,
but your formula looks very promising. Many thanks.


--
pdgood
------------------------------------------------------------------------
pdgood's Profile:
http://www.excelforum.com/member.php...o&userid=31623
View this thread: http://www.excelforum.com/showthread...hreadid=522444