Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Commenting a block of code in VBA
- Downloads
- Drawing in Excel 7 - Creating drawings from coordinates
- Downloads by category
- Using Goal Seek on Multiple Cells
- Retrieving unique values from a range or array ...
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Benata on Ana Vidović mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd…
Category Archives: Charts
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
1 Comment
SectionProperties update 3
The SectionProperties spreadsheets previously posted had limited graphics capabilities due to problems with the plotting routines causing Excel to crash. I have now fixed that problem by updating some Python libraries with pip: installing mkl-service numpy 1.21.2 -> 1.22.1 Pillow … Continue reading
Posted in Beam Bending, Charts, Charts, Coordinate Geometry, Excel, Finite Element Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL
Tagged Excel, Python, PyXLL, Section-Properties, Torsion, Warping
2 Comments
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
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
Computing and plotting the Mandelbrot set in Excel …
… with Python, Numba and pyxll. As promised in the previous post, this post will look at alternative procedures for calculating and plotting the Mandelbrot set with Python based code. The spreadsheet presented here and the associated Python code may … Continue reading
Posted in Charts, Charts, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, guvectorize, Mandelbrot Set, MatPlotlib, Numba, Python, PyXLL, UDFs
Leave a comment