Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Fitting high order polynomials
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Lateral pile analyis with PY curves ...
Recent Comments
Tag Archives: MatPlotlib
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
More Matplotlib problems
Following an upgrade to some Python libraries, I found that problems with plotting from Matplotlib causing Python to crash were recurring (previously reported here). When called from Excel with pyxll this was also causing instant crashes of Excel. I eventually … Continue reading
Posted in Excel, Link to Python, PyXLL
Tagged Excel, freetype, MatPlotlib, plot causes crash, Python, PyXLL
3 Comments
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
Contour plots with Excel and Matplotlib – 2
The procedures discussed in the previous post required the contour data to be arranged on a regular rectangular grid, with the data points listed in a 2D array. As far as I know there is no built in alternative in … Continue reading
Posted in Arrays, Charts, Excel, Finite Element Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged Contour plots, Excel, MatPlotlib, Python, PyXLL
Leave a comment
Contour plots with Excel and Matplotlib
Contour plots are widely used for a great variety of purposes, but facilities for producing them in Excel are very limited, and those that are provided are very well hidden. In this post I will look at some simple examples … Continue reading
Posted in Arrays, Charts, Charts, Excel, Finite Element Analysis, Link to Python, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged Contour plots, Excel, MatPlotlib, Python, PyXLL, UDFs
Leave a comment