Digitising logarithmic scales

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. Yes! This is exactly what I meant🙂

    Excellent job!

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


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

  3. george lungu says:

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


  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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s