Category Archives: Charts

Text from pictures in Excel

Posted on 05/09/2025 by dougaj4

Excel recently added the ability to extract text from an image, either on the clipboard or from a selected file. To try this out I used a screenshot of a table with vertically aligned text, from a pdf copy of … Continue reading →

Posted in Charts, Excel | Tagged , , , | Leave a comment

Plotting Carlyle’s Circle with Matplotlib in Excel

Posted on 25/07/2025 by dougaj4

Recently I happened to read of Carlyle’s Circle, which is a circle that has two intersection points with a parabola on the X axis. See the Wikipedia article for more details: https://en.wikipedia.org/wiki/Carlyle_circle This post looks at the options for plotting … Continue reading →

Posted in Charts, Drawing, Excel, Link to Python, Maths, Newton, PyXLL, UDFs | Tagged , , , , , , | Leave a comment

Dynamic charts

Posted on 23/07/2023 by dougaj4

A frequently asked question is how to get Excel charts to automatically update when new data is added outside the original selected ranges. The most frequent recommendation (such as here) is to convert the data to a table, then insert … Continue reading →

Posted in Charts, Charts, Concrete, Excel, UDFs | Tagged , , , , , | Leave a comment

3D Matplotlib Plots in Excel

Posted on 17/04/2022 by dougaj4

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 , , , , , , | 2 Comments

SectionProperties update 3

Posted on 09/02/2022 by dougaj4

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 , , , , , | 3 Comments