Tag Archives: plot function

Automating chart scale limits – update

Posted on 25/11/2012 by dougaj4

I wrote about this function 2 1/2 years ago, and promptly forgot about it, but a few days ago brian provided an answer to a question that was raised shortly after it was first posted, concerning how to apply the function … Continue reading →

Posted in Charts, Excel, UDFs, VBA | Tagged , , , , | 13 Comments

Charting a Mathematical Function with Defined Names

Posted on 15/12/2010 by dougaj4

This post is a compilation of information from Stephen Bullen, Jan Karel Pieterse, and George Lungu.  To quote JKP “When doing mathematics, wouldn’t it be nice if we could type an equation into a cell in Excel and immediately see … Continue reading →

Posted in Arrays, Charts, Excel, Maths | Tagged , , , , | 7 Comments