Tag Archives: digitize scanned image

Daily Download 10: Excel Digitiser

See How to digitise a scanned image and Digitising logarithmic scales.  This spreadsheet provides a function to retrieve coordinates of lines traced over a scanned image. Download from: http://interactiveds.com.au/software/DigitGraph.zip Example images:

Posted in Drawing, Excel, Newton, UDFs, VBA | Tagged , , , , | Leave a comment

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, … Continue reading

Posted in Excel, UDFs, VBA | Tagged , , , , | 4 Comments

How to digitise a scanned image

For instance, suppose we had a graph from a technical paper, and we wanted to extract numerical data from the graph lines.  One way would be to measure the points by hand and calculate the numbers by scaling from the … Continue reading

Posted in Drawing, Excel, UDFs, VBA | Tagged , , , | 14 Comments