>
>This is exactly the type of thing that I'm doing. In my case its Pressure against temperature - as pressure increases, the maximum allowable temperature should decreases. Each set of figures produces an arch which can be clearly seen with a graph.
>
>I would be most grateful if you could dig out the class. It would save me so much time (and embarrassment if I get it wrong).
>
>Jason
OK then Jason :) Funny I started to do that with MSGraph too and had the same exact feelings about speed :)
I just fired the email. Here are few things I forgot to mention there. It's a "depth" graph. That's from sea surface to depth which users like to see positive values for depth yet Excel cannot do w/o tooth pulling tricks :) OTOH I especially coded to get a depth graph you should need the revise code (but as I remember just affected in a few lines calculating Y pos at about ends of redraw method). Those days I didn't have a good habit like commenting what part does what :( Hope it won't be a trouble.
Cetin