Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Lateral pile analyis with PY curves ...
- Deflections and Moments in Rectangular Plates
- Fitting high order polynomials
- Downloads
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
Recent Comments
Category Archives: Drawing
3D Matplotlib Plots in Excel
As well as Excel, the code shown in this post requires current versions of Python, Numpy, Matplotlib, and pyxll. The required import statements at the head of the Python code are: The spreadsheets and Python code described below may be … Continue reading
Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, MatPlotlib, Plot 3D images, Python, PyXLL, Rotate 3D images, UDFs
Leave a comment
Display Matplotlib animations in Excel
The latest version of pyxll (5.4.0) allows animations generated in Matplotlib to be simply copied to Excel. A spreadsheet with the examples shown below, and the associated Python code can be downloaded from: Animations2.zip The screenshot below shows the simple … Continue reading
Posted in Animation, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged animation, Excel, Mandelbrot animation, Mandelbrot Set, MatPlotlib, Python, PyXLL, UDFs
1 Comment
Plotting Mandelbrot in Excel with Matplotlib
The functions used in the previous post generate an array of integers, the number of iterations for the function return value to exceed 2. This post looks in more detail at how this data can be plotted in Excel using … Continue reading
Posted in Charts, Charts, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged cmap, Excell, imshow, Mandelbrot, MatPlotlib, Python, PyXLL, UDFs
Leave a comment
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