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.
Yes! This is exactly what I meant 🙂
I’ll play with it a little during the weekend…
Pingback: Excel as a digitizer « Excel Tips Monster
I apologize, the first number (artifact) was the number of points. My fault…
Pingback: Daily Download 10: Excel Digitiser | Newton Excel Bach, not (just) an Excel Blog