Category Archives: Charts

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 , , , , , | 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 , , , , , , , | 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 , , , , , , , | 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 , , , , , , | Leave a comment

Copying charts to a new workbook

When an Excel worksheet including a chart(s) is copied to a new workbook the chart still links to the data ranges in the original workbook. Over the years I have spent a fair bit of time editing the chart ranges … Continue reading

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