### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Using Goal Seek on Multiple Cells
- Commenting a block of code in VBA
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The Conjugate Beam Method
- Cubic Splines
- Downloads by category
- Daily Download 8: Drawing in Excel

### Recent Comments

dougaj4 on Tanh-Sinh Quadrature v. 5… metroxx on Tanh-Sinh Quadrature v. 5… dougaj4 on Tanh-Sinh Quadrature v. 5… metroxx on Tanh-Sinh Quadrature v. 5… dougaj4 on Numerical Integration With Tan… Tanh-Sinh Quadrature… on Numerical Integration With Tan… Graeme Dennes on Numerical Integration With Tan… John Maddock on Numerical Integration With Tan… John Maddock on Numerical Integration With Tan… Charles Chika on Frame Analysis with Excel… dougaj4 on Weighted Least Squares Regress… NotOP on Weighted Least Squares Regress… Installing PyPardiso… on Making Finite Element Analysis… John Maddock on Numerical Integration With Tan… Graeme Dennes on Numerical Integration With Tan…

# Category Archives: Drawing

## Using Matplotlib from Excel with pyxll

The pyxll documentation has many examples of plotting in Excel using Matplotlib and other packages, but I find the multiple options confusing and hard to follow, so this post works through the examples in the Matplotlib Users Guide tutorial. The … Continue reading

Posted in Charts, Charts, Drawing, Excel, Link to Python, PyXLL, UDFs
Tagged Excel, Graphs, MatPlotlib, plotting, Python, PyXLL, UDFs
Leave a comment

## DigitGraph Spreadsheet and WebPlot Digitiser

I have posted here previously a spreadsheet that allows XY data to be extracted from images of graphs, maps or other images of objects in a single plane: How to digitise a scanned image. I have updated the instructions for the … Continue reading

Posted in Charts, Charts, Computing - general, Curve fitting, Drawing, Excel, UDFs, VBA
Tagged DigitGraph, digitize scanned image, Excel, UDF, VBA, WebPlot Digitizer
5 Comments

## Plotting Mandelbrot

There are many sites discussing the Mandelbrot Set, but not many examples using VBA to plot the set in Excel, so here is my effort: The spreadsheet (including open source VBA code) may be downloaded from: Mandelbrot chart.zip Note that … Continue reading

Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA
Tagged Charts, Excel, Mandelbrot Set, VBA
3 Comments

## Arcs and arc-splines

I have added two user defined functions (UDFs) to the IP2 spreadsheet to generate coordinates for a single arc, or a series of arcs connected (if necessary) by straight lines. The new version may be downloaded from: IP2.zip As an example … Continue reading

## More Python rotation functions

The code described in the previous post includes a Python function that rotates 3D coordinates by an angle defined with two vectors, using Rodrigue’s Rotation. I have now added this function to the IP2_py spreadsheet, where it is used in the … Continue reading

Posted in Coordinate Geometry, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Excel, fit 3D circle, Numpy, Python, RPView, UDF, VBA, xlwings, xl_RPView
Leave a comment