Digitising logarithmic scales

Posted on April 16, 2010 by dougaj4

At the suggestion of the Exceltipsmonster, I have modified the DigitGraph spreadsheet presented in the previous post to also work with logarithmic scales. Dowload the updated spreadsheet from here.

The function now has two additional optional arguments, Xlog and Ylog:

 =DigitGraph(Shape Name, Xmax, Ymax,  Xorigin=0, Yorigin=0 ,Xlog=False ,Ylog=False)

Either or both scales may be entered as True, in which case the corresponding origin value must be greater than zero.

Log-Log graph example, click for full size view

This entry was posted in Excel, UDFs, VBA and tagged , , , , . Bookmark the permalink.

4 Responses to Digitising logarithmic scales

  1. exceltipsmonster says:
    April 16, 2010 at 9:11 pm

    Yes! This is exactly what I meant 🙂

    Excellent job!

    I’ll play with it a little during the weekend…

    Like

    Reply

  2. Pingback: Excel as a digitizer « Excel Tips Monster

  3. george lungu says:
    May 13, 2011 at 12:05 pm

    I apologize, the first number (artifact) was the number of points. My fault…

    Like

    Reply

  4. Pingback: Daily Download 10: Excel Digitiser | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.