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

### Like this:

Like Loading...

*Related*

Yes! This is exactly what I meant 🙂

Excellent job!

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

LikeLike

Pingback: Excel as a digitizer « Excel Tips Monster

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

LikeLike

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